ExcelBanter - Sheet name to string variable

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Sheet name to string variable (https://www.excelbanter.com/excel-programming/340267-sheet-name-string-variable.html)

Greg Billinge

Sheet name to string variable

Hi,

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

Thanks in advance

Greg

Bob Phillips[_6_]

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

Stefi

Sheet name to string variable

yourvariable = Activesheet.Name

Stefi

€žGreg Billinge€ ezt Ã*rta:

Hi,

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

Thanks in advance

Greg

All times are GMT +1. The time now is 02:43 PM.