array
apologies if this is a duplicate - I'm having issues with the ng reader
but can you rephrase the question please?
meantime you could change the formula a bit:
xxxxx=Range( Range("e3") , cells( Range("m65536").end(xlup).row, "M") )
"RobcPettit" wrote in message
...
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
|