Link to different tab on worksheet

  • Thread starter Thread starter alsweb
  • Start date Start date
A

alsweb

Kevin,

I entered the macro precisely as given, character by
character (it is my first attempt at doing this).

When I run the macro through the "tools" menu, it
returns "Sub GetNames()" into column A below the macro,
not the list of worksheet names.

What am I doing wrong?

Thanks,
Alsweb
 
When you say "I entered the macro precisely as given, character by
character."
What did you do?
All you need to do is highlight the text in the email>copy>paste into a
module.
 
alsweb,

I didn't see your message earlier, so if you are still struggling....

Press Alt F11, and that takes you into the VBE (Visual Basic Editor).

Go Insert | Module, and then just do a copy paste of the subroutine I had
given earlier.

Remember too, that after creating your subroutine, you need to add a
worksheet called "MyNames" without the quotes.

If you are still having difficulties, come back and someone will assist.

Regards,
Kevin
 
Kevin,

Thank you for your patience. As a result of your
additional assistance, the macro worked. Linking the
worksheets with the formula you recommended earlier worked
flawlessly. I am very grateful for your support.--

Alsweb


Original Message-----
 
alsweb,

You are most welcome. We (Don, Gord, and myself) thank you for coming back
and letting us know it is mission complete.

Regards,
Kevin
 
Back
Top