Thread: array
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
RobcPettit[_2_] RobcPettit[_2_] is offline
external usenet poster
 
Posts: 108
Default array

Hi, at the moment Im using xxxxx=Range("e3:m" & Range("m65536").end
(xlup).row) to add data to my array. I only use the data in col E col
M, which in my array is xxxx(1,1) and xxxx(1,9). (records are added
each day, currently 2 thusand). I cant rearange the data in the
spreadsheet so the data is beside each other. This works fine, does
what I want. Just would like to know if there is a way to add only
the columns I want. Trying to tidy up my code, and gain any time, be
it miliseconds, that I can. Thanks for any advice.
Regards Robert