PDA

View Full Version : Create a Const that references a Range



samkhalilian
08-16-2010, 03:28 AM
Hi,

Is it possible to create a Const that references a Range i.e.

Public Const MyConst As Range = Range("A1")

Cheers, Sam

Bob Phillips
08-16-2010, 03:48 AM
No.

samkhalilian
08-16-2010, 03:51 AM
why?

Bob Phillips
08-16-2010, 04:30 AM
Try it and see.