Linc,
The 'Dim' statement is used to declare a variable (its name is short for
'Dimension', going back to the earliest days of the BASIC programming
language), and the 'As Long' indicates what type of variable is being
declared. A Long type of variable is 4 bytes in length, and can contain a
whole number between about +/- 4 billion.
So the statement
Dim Index As Long
essentially tells VBA to declare a Long type variable and give it a name
'Index'. Code can then store whole numbers between +/- 4 billion in this
variable.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Linc" wrote in message
...
Can you tell me what this part of your code is doing?
<SNIP
Dim clSheets As Collection
Dim ws As Worksheet
Dim index As Long
Set clSheets = New Collection
<END SNIP
I don't really know what 'DIM' is asking and what 'Long' is all about.
Linc
Sorry, very new at this.
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/