[AccessD] Setting data into and getting data from Named Ranges

Hi John

Don't do it that way. Set a range object and read/write from/to it.

  Set wkb = <yourworkbook>
  Set rng = wkb.Range(strRangeName)

Read from a range into an array:

  avarValues = rng.Value

Write from an array into a range:

  rng.Value = avarValues

/gustav

>>> jwcolby at ColbyConsulting.com 23-01-2006 16:34:57 >>>
OK, to SET a value:

SomeBook.Names(strRangeName).RefersToRange = val 

To read a value:

SomeBook.Names(strRangeName).RefersToRange

Only tested for single cell ranges, and setting the SAME VALUE into square
ranges ("tables").

John W. Colby
www.ColbyConsulting.com