View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
banavas[_2_] banavas[_2_] is offline
external usenet poster
 
Posts: 1
Default data from a sheet to a matrix

Dear Friends,

how can save data from an excel sheet into a two dimensional array i
order to perform for ... next i operations?
Out of your experience is it memory wise better to store data in V
variables and work with them or to work directly with the spreadshee
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