Hyperlink looping through a range

[darbar82]

Hi,
Summary of my issue

- each workbook contains 100 worksheets, each one a project

- the project start dates move frequently meaning an update is necessary

- i'm trying to loop through the range, follow each hyperlink to the different worksheets and update the start date to the value in row 4 which is always cell A12 on the project worksheet


Problem

- when i run the code here, it only updates the active sheet [A12]

example, P-Two represents the tab called 'Project2' and i would like to get '01/04/13' into cell A12 on that tab


any help would be greatly appreciated and am sure there will be a 'doh' moment for me if somebody is kind enough to help.loop through range with hyperlink.xlsm

[Norie]

Your code has a few errors in it, even before you reach the hyperlink part.

For example, Cell isn't defined when this code is executed so it causes an error.

Please Login or Register  to view this content.

You won't see that error though as you have On Error Resume Next, the code will be skipped and StrMth will stay at it's default value of 0.

What is Cell supposed to refer to?

The next error you won't see is here.

Please Login or Register  to view this content.

VBA will be looking for a named range called 'rng' when there isn't one.

That will also cause a problem here as Cell is Nothing.

Please Login or Register  to view this content.

[/code]

The only line of code that won't error is this one, but all it will do is put 0 in A2 on the active sheet.

Please Login or Register  to view this content.

This code will run without error and it seems to work to some extent, but I'm not sure it does everything you want it to.

Please Login or Register  to view this content.

[darbar82]

That's absolutely perfect thanks. The rng was a hangover from another piece of code but not naming the cell variable was terrible on my part!
Many thanks for taking time to reply, its exactly what i need as a already have the code to update the rest.