I have a workbook with several sheet within and in column ther may or may not be e-mail addresses. If there is an e-mail address I want to make it hyperlink ready, I don't want to follow it or execute just make it available to be clicked on. I have some code that I am using to loop through the book and it's sheets.
Hope this help someone that can help me - thanks in advance
Please Login or Register to view this content.
Last edited by dkub; 05-26-2011 at 12:23 PM. Reason: Solved - some great help
dkub,
Give this a try:
Please Login or Register to view this content.
Hope this helps,
~tigeravatar
Hello dkub,
I made a few changes to macro to add the hyperlinks for email addresses.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Thanks - bunchs they both work just fine - great help - thanks again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks