View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas Gary Keramidas is offline
external usenet poster
 
Posts: 2,494
Default how to select a sheet by name

Worksheets("0").Activate

--


Gary


wrote in message
ups.com...
Hi guys,

How can I go to a sheet by name, for example

I have a=0 (a is a string, not integer) and a sheet named 0. How can I
select the sheet using variable a?

Thanks for the help!

J. Zhao