98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft VBA Training and help » Excel VBA variable type
Excel VBA variable type
Resolved · Medium Priority · Version 2003
Wed 24 Feb 2010, 10:35Delegate Anna said...
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.
Wed 24 Feb 2010, 10:43Trainer Stephen said...
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
Tue 2 Mar 2010: Automatically marked as resolved.
Training information:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
VBA tip:Count the Rows and Columns in a SelectionIf you need to count the number of rows or columns in a worksheet use the following code: |
