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

array
 

not sure what you mean, Can you rephrase the question please?

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

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

array
 

Thankyou for replying. I have data in column e through to m. Say 20
rows down, rows added daily. At the momment I fill my array with this
data and work on col e and m. But ofcourse inbetween I have data for
f,g,h,i,j,k an l. Idont do anything with this data. But I keep the the
data as is on the spreadsheet. The data in e and m is added to another
sheet. What Im trying to do if just add col e and m col data in the
array. The same as if I just deleted the cols betweem e and m and
added that to the arrar. I hope that makes sense.
Regards Robert