Defined named range to array

  • Thread starter Thread starter MattShoreson
  • Start date Start date
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
 
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.


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to
Click to expand...
creating financial statements
 
Back
Top