Anna has attended:
Excel VBA Advanced course
Excel VBA variable type
I want to set a sheetname within an excel workbook as a variable but can't work out which type of variable it should be set as.
RE: Excel VBA variable type
Hi Anna
Thanks for your question
I am assuming you are refering to the name of a worksheet, rather than the worksheet object itself.
A worksheet's name is always a string. This is because it is the worksheet's key property which is used to identify it.
Thus, your variable should be a string.
Regards
Stephen