>I have several applications that load variable size spreadsheets into arrays.
>So far I have just just used fixed sized  arrays (DIMed at startup).
>One is fixed at 600x600 and another application is uses 8x8000.
>Can someone recommend some good examples of using arrays that adjust as
>needed?
>I would like my applications to be limited by the end-user's memory and not by
>an arbitrary size that I pick.

i would look at the XREF FAQ. It got me started on this and is very well
written.
What I tend to do is use a global XREF@ thingy in the situation you
describe. I can allocate memory as needed as the array grows (or needs to
grow) and am only limited by RAM.

I have a demo (which really is just a PG conversion of the FAQ code) if you
want it.

Cheers

David