I am new to VBA and coding in general so hopefully I am wording this correctly. I am trying to write a sub routine that that runs when a user paste a file’s address/path into a range of cells (“B11:B9999”). It then turns that target cells pasted into a hyperlink with the FileName variable as the text. Please see what I’ve gotten so far.
Looks like the error is where I am adding the Hyperlink. Not sure of the syntax, any help would be greatly appreciated!!
Please Login or Register to view this content.