Link to different tab on worksheet

[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

 

[Don Guillett]

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.

 

[Kevin Stecyk]

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

 

[alsweb]

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-----

 

[Kevin Stecyk]

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