Copy entire column or only to end of range

Good afternoon folk

Excel 2010

I'm currently working on a spreadsheet where I will be looking at copying a variable length column of data..... looking at anywhere between 70,000 and 115,000 rows of information each time....

Is it better to copy the entire column ( A:A) or just until the end of the range


Many thanks

JT

Go with end of range, as you mention lsat data row differe.

Always want to limit to range to save resource and processing time

Using

Please Login or Register  to view this content.

You could add in a for loop for the number of columns to decide the variance

Please Login or Register  to view this content.