jeffcoleky
Active Member
- Joined
- May 24, 2011
- Messages
- 274
Two great board members helped me create this formula to auto-hyperlink my cells based on their contents HERE. Since it's a new question i'm starting a new post.
I need my auto-hyperlinking formula to be converted to a macro instead. Can anyone help?
The macro needs to be applied to the SELECTED cells when run.
Here's the Formula:
Anyone?
I need my auto-hyperlinking formula to be converted to a macro instead. Can anyone help?
The macro needs to be applied to the SELECTED cells when run.
Here's the Formula:
Code:
[I]
=Hyperlink( ".\" & "PDFS" & "\" Substitute(A1," ", "") & ".pdf", A1)
[/I]
Anyone?