I am using the sub below to create hyperlinks. The problem that I have with this sub is that it converts what looks like a date into date format and what looks like a number to a number. What I want is that it uses the 4 characters as text. How do I avoid that what looks like a number is converted to number and what looks like a date is converted to date format.
Please Login or Register to view this content.HTML Code:HTML Code:
Last edited by dschmitt; 10-15-2014 at 10:09 PM.
I found the solution.
Instead of assigning a Text-To-Be-Displayed in the Hyperlink.Add statement I linked the hyperlink address to an existing string.
Please Login or Register to view this content.
Another method...
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
AlphaFrog, it works. Interestingly. adding ' in front of the 4 characters in column A doesn't work.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks