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

-----------------------------------------------
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com

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

Hi Matt,

You can get value as an array.

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




"MattShoreson" wrote in message
...

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.


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/

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