Defining multiple variables

[Puffin617]

Hi,

If I define many variables as range, do I have to define each one "as range" or can I list them all and then just say "as range" once?

 

[VoG]

You need to define each one

Dim a, b as Range

declares a as Variant and b as Range.

You need

Dim a as Range, b as Range

 

[Puffin617]

Thanx