read the values in a range and store them in macro
 

As long as the other occasion is before you close the workbook.

Public vArr as Variant


Sub InitvArr()
vArr = worksheets(1).Range("A1").Resize(10,20).Value
End sub

--
Regards,
Tom Ogilvy


DL wrote in message
...
Is it possible to read the values in a range and store them in a macro for
use on another occasion?