banavas < wrote:

Dear Friends,

how can save data from an excel sheet into a two dimensional array in
order to perform for ... next i operations?
Out of your experience is it memory wise better to store data in VB
variables and work with them or to work directly with the spreadsheet
with Range("").Select etc. commands?

Additionally, is there a way to speed up the vlookup operation?

Thank you in advance.


---
Message posted from http://www.ExcelForum.com/

Not sure what you mean by "memory wise", but it's certainly likely to be
faster using arrays.

Alan Beban