Excel VBA variable type

Resolved · Medium Priority · Version 2003

Wed 24 Feb 2010, 10:35 Delegate 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:43 Trainer 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 courses

	98.8 % recommend us
	More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

VBA tip:

Count the Rows and Columns in a Selection

If you need to count the number of rows or columns in a worksheet use the following code:

Selection.Rows.Count - Returns the number of rows in the selection

Selection.Columns.Count - Returns the number of columns in the selection

Selection.CurrentRegion.Rows.Count - Returns the number of rows in the current region of the selection

View all VBA hints and tips