object question

[lvito001]

when declaring something "As Object"... what does that mean exactly?

[Bob Phillips]

It means that you are creating a generic object variable, and can set it to any object type, such as a Range, a workbook, a shape.

It is most commonly used when you would be accessing many different object types, but you don't know in advance what types you will encounter, such as iterating through the controls on a userform (where you can have texboxes, buttons, checkboxes, etc.).

[lvito001]

thanks very much, xld! :clap: