Hi

From the excel help file

Dim: Declares variables and allocates storage space

Set: Assigns an object reference to a variable or property

If you don't have option explicit, then you can use a set statement without using a dim statement, but if you have option explicit, then you must have a dim before you can set.

Tony