 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
05-22-2008, 05:47 PM
|
|||
|
|||
|
Re: Check for hyperlink
In code or manually?
In code: if activecell.Hyperlinks.Count = 0 then 'no hyperlink else 'yep end if Manually, I'd just mouse over the cell--or ctrl-k to see what shows up. Jan Kronsell wrote: > > Is there anyway to check if a cell contains a hyperlink? > > Regards > Jan > > -- > For den, der kun kender en hammer, > komme alle problemer hurtigt til at ligne søm. -- Dave Peterson 
|
|
05-22-2008, 06:00 PM
|
|||
|
|||
|
Re: Check for hyperlink
Thank you - code it is then. I just thought that there might be a function
like ISNUMBER but then I'll just make my own .-) Regards Jan Dave Peterson wrote: > In code or manually? > > In code: > > if activecell.Hyperlinks.Count = 0 then > 'no hyperlink > else > 'yep > end if > > Manually, I'd just mouse over the cell--or ctrl-k to see what shows > up. > > Jan Kronsell wrote: >> >> Is there anyway to check if a cell contains a hyperlink? >> >> Regards >> Jan >> >> -- >> For den, der kun kender en hammer, >> komme alle problemer hurtigt til at ligne søm.
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
