Declare variable

[spavakongboon]

Help me, I don't know how to declare Constant Array at module level in VBA.

Any help would be appreciated

 

[Ron Morris]

Hi,

Try something like this:

Const sourcerange as string = "A1:C3000"

Then you will have to Call the sourcerange in code later down the line.

Ron