On excel 2003, is it possible to get a macro to find all the cells which are named a particulur thing in a particulur range? if so, what is the code for this.
excel 2003 uses visual basic 6.5
I appreciate any help you could give me.
Thank you

Hello, i am a complete beginner with visual basic so lets see if i can explain my problem.
I've got microsoft excel 2003 which has got Visual Basic 6.5 and i need to create a macro which will click on the hyperlink in a particulur cell, problem is, i only want to click on the cells that are highlighted. So question is, whats the code to make sure the macro only clicks on the cells that are highlighted?

Thanks for your help,...