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/