RE: Variables

Hi Dean

Thank you for your question

The set command is used when allocating a value to an object variable. There are two types of variable. Simple value variables such as strings or integers, take a single value and those values can be allocated without a set command.

For example

strName = "Fred"

Object variables can be set to represent real objects and can then be used to set various propeties of the object

Hence

SET SheetVar = Activesheet


Regards

Stephen