Both End(xlDown)and End(xlUp) are doing the same! is this logic?

[Emma_B]

I am using code below to copy all cells with values in a column and copy it in another column in another page. I tested the code with End(xlDown) and End(xlUp) and both are working!. can anyone explain what is the difference. and which one is the right one to use.

Note: I got this code with help of some good fellows in this forum so I don't really understand how it is explained.

Please Login or Register  to view this content.

/E

[briguin]

Spaces...
The End(xldown) is like doing a Ctrl+down Arrow.
If there is a space the down will stop at the space.

the xlup is doing ctrl+up arrow until it hits top or space.

Both will work if you are sure there are no blank spaces in the column

I generally like to start at bottom of sheet 1000000+ rows and ctrl+up = End(xlup)

[nilem]

Hi Emma_B,
try

Please Login or Register  to view this content.

[Emma_B]

not really, it does not stop when there is blank cells, it copy all the cells with values in the column. look in the attached sample.

[Emma_B]

Thanks nilem, the (With) method works faster.

How can I reference to a named cell. "B2" in sheet1 is a header named "Status" and "D1" in Sheets2 is named "Updated_Status". how can I reference to these named cells with offset code.

/E

[jagadeesh.rt]

Hi Emma,

Please have a look from the below link: Brief notes.

VBA codes to determine Last Used Row & Last Used Column in Excel
http://www.globaliconnect.com/excel/...=79&Itemid=475