Hi All,
I need a macro to perform a looped operation on a single column of data on an Excel spreadsheet. The column in question contains filepaths to files on the company's network. I need the macro to convert those filepaths into a ready-to-click hyperlink to the corresponding file, and for the hyperlink to read "Click to View."
The macro has to be looped so that it will perform the operation until it reaches the end of records in the spreadsheet. Further, the macro has to be saved, such that it will be available to the user regardless of what spreadsheet she's working on (I'll duplicate the macro as necessary for all my co-workers who'll be using it).
The problem is complicated by the fact that a blank cell in the "Filepath" column is not a good indicator of the end of the loop. This is because some rows will simply have records that contain no filepath. The only safe indicator of the end of the loop is where the operation hits the point at which ALL cells in the row are blank. That would truly spell the end of the operation.
This is a doozy, it seems, especially for me, since I've only written a limited number of macros. But if anyone here can swing this, I'd sure appreciate it. You'd be preserving my retreating hairline : )
Bookmarks