Defined named range to array

M

MattShoreson

I would like to know if it's possible and preferably the syntax also fo
assigning values to an array using a named range.

cheers,
Matt
 
C

Colo

Hi Matt,

You can get value as an array.

Dim a as variant
a = Range("NamedRange").value




MattShoreson said:
I would like to know if it's possible and preferably the syntax also for
assigning values to an array using a named range.

cheers,
Matt.
creating financial statements
 
Top