I used IE 5.50.4522.1800IC to copy and paste account activity information from a mutual fund into a spread sheet. All of the items in the ‘description’ column on the original web page are hyperlinked to detailed information. Even with that web page open in IE, the links saved in the spread sheet do not run. The links do make the Excel file much larger.
I tried to record a macro to unlink them (move down one cell, right click, choose hyperlink, choose remove hyperlink). When I checked the macro it specified the address of the exact cell into which I had moved the cursor rather than recording the action (move down one cell.)
Is there a simple way to get the action recorded?
Do I need to be concerned that the macro recognize when there are no further hyperlinks to find and remove, i.e., would a crude macro just keep moving down one cell and trying forever?
Perhaps something as simple as an iterative process that worked for 10 or 20 cells in succession would be a kluge to get around this problem?
Thanks for any insights,
John