Thread: Setting variable = to sheet name
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
  
Posts: 3,885
Default Setting variable = to sheet name
Hi
SheetName = activesheet.name

--
Regards
Frank Kabel
Frankfurt, Germany


Jeff Armstrong wrote:
I have a simple question. What is the code to set a
variable to the name of the activesheet in Excel?\

Dim SheetName As String

SheetName = <code?

Jeff
Reply With QuoteReply With Quote