Hi I am having a problem in assigning a hyperlink to a cell if the cell data matches files from folders and sub folders
This is the particular line that I am having trouble with:
If ActiveCell = File_Name Then ActiveCell.Hyperlinks.Add ActiveCell, Address:=File_Path
Although the File_Name and the activeCell value appear the same the line does not recognize that
Any help that you can give would be appreciated
Please Login or Register to view this content.
Thanks in advance
This comparison is case sensitive. Try this to make it case insensitive.
This is not looping through the cells. The Active cell never changes.Please Login or Register to view this content.
Instead of using a nested loop (loop through file names and then loop through cells), you could loop through file names and use the .Find method to look for a match. Try this (not tested)Please Login or Register to view this content.
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.
Thank you, I used your last suggestion and it worked fine
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks