Follow hyperlink and get date?

Sorry to all who have looked, I ment to remove existing macros.

If when looking you get a runtime error just "End"

Once again guys sorry.

Keith

hi Keith, option, please check attachment

Hi thanks for your reply and sorry for the delay in me answering you.

I have looked at the file you attached but get a runtime error 1004 "method rows of object_global failed.

When I select "debug" the line below is highlighted:

lrow = crew_names.Cells(Rows.Count, 1).End(xlUp).Row

If I select "end" I seem to have the required result, but, only for the first eight people.

Regards,
Keith

try to change this line:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Good Morning,

Thank you for the code change. With this change it appears to work correctly.

My only concern is that although the code is in the workbook open event, it would normally be in ThisWorkbook (I think) it says YoaEieaa with characters above each letter. Is this likely to cause problems?

ThisWorkBook.JPG

Also, is there any chance, that now it is working as expected, you could put in some comments so I may try and understand how it does what it does.

Thank You,
Keith

ThisWorkbook being unreadable issue corrected, comments added

OOPs, same runtime error as previous only this time on line:-

icol = Range(subaddr).Column

Regards
Keith

change this to:

Please Login or Register  to view this content.

Thank you for the revision, it’s probably easy “when” you know how, I have a l o n g way to go yet.

Everything seems to be working now as expected, so I will mark as solved.

Thank you for your time and patients,

Keith

you are welcome Keith