Arrays - naming & retrieving from named arrays | Excel forum

Hi,

I am trying to create an array which I then save as a named array so that I can save a version of the file it was created from without the very large data worksheets but still retain the info in the code from which it can be accessed.

I have created the array & written back from it with no problems, but cannot get the name bit to work - I just get an 'application or object defined error.'

My code so far is:
Dim byT3(1 To 5, 1 To 439, 1 To 143) As Variant
Dim intRowCount As Long
For intRowCount = 3 To Sheets("data2").Range("a1")
byT3(1, Cells(intRowCount, 2), Cells(intRowCount, 3)) = Sheets("data2").Cells(intRowCount, 8)
Next intRowCount
Names.Add Name:="T3data", RefersTo:=byT3

I can't see what is wrong with this compared to the example in the course handout but it isn't working! (it fails on the last line)

Also, once I get it to work, how do I call back the data using the name? Is it just the same except the data remains in the array memory even after the file is closed & re-opened?

Thanks for any help
cheers, Paul