Hi. I'm often in the position of using large (40,000 rows or more) sets of
data.

And I'm often merging the data with other data - which I prefer to do using
vlookup.

As often as not - this is a one time project - so I'm hesitant to move the
whole thing to Access (which is not supported in our company - nor is it as
user friendly in my opinion).

Any ideas on how to improve my hardware to reduce crashing?

I've upgraded to 528 mb of RAM

thanks,
beata