Thread: Sheet name to string variable
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
  
Posts: 11,272
Default Sheet name to string variable
myVar = Activesheet.Name

--
HTH

Bob Phillips

"Greg Billinge" wrote in message
...
Hi,

How do you set a string variable to the name of the active worksheet?

Thanks in advance

Greg


Reply With QuoteReply With Quote