Convert 2003 macro to 2010

[pxg133]

Hi ,

I have a macro that was created in excel 2003 to auto update hyperlinks and move them to a second location on the workbook renamed. This action repeats for as many rows that have data. It works fine in 2003, but neither returns the correct hyperlinks, nor populates as many links as there is data. I have tried saving the doc with macro enable, chnaging the trust settings, copying the code into a brand new workbook, but nothing works. I'm supposing that the syntax between 2003 and 2010 differs, but am not familiar enough with VBA. The initial error messages I'm getting are related to the line: Range("Q" & rowNUMBER).Select

Here's the whole code, any help is appreciated!!

Please Login or Register  to view this content.

[Cutter]

Hello pxg133, and welcome to the forum. I have added code tags to your post. The forum rules require them so please keep that in mind when showing code in any future posts.

Thanks, and here's the rule:

RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

[pxg133]

Hi Cutter, Thanks for adding code tags for me, I've not used them before and would be quite lost to start.