how to select the last two row

[poppypoppy]

Hi,

I know use Range("w65536").End(xlUp).Select to direct last row, but how to get last two row value?

Thanks

[Domski]

Maybe:

Please Login or Register  to view this content.

Not sure what you are doing but it's worth noting it's almost never necessary to use Select in VBA code.

Dom

[JBeaucaire]

Domski is right. IF you look at the next thing you were going to do after selecting, that line of code was probably going to start with Selection..... so you can usually just merge all those lines together at the Select/Selection overlap.

Please Login or Register  to view this content.

In your code, if the next thing you were going to is copy the entire row, take off the select and immediately copy the entire row:

Please Login or Register  to view this content.

[poppypoppy]

Excellent. It works. Thanks

Maybe:

Please Login or Register  to view this content.

Not sure what you are doing but it's worth noting it's almost never necessary to use Select in VBA code.

Dom

[poppypoppy]

Thank you so much

Domski is right. IF you look at the next thing you were going to do after selecting, that line of code was probably going to start with Selection..... so you can usually just merge all those lines together at the Select/Selection overlap.

Please Login or Register  to view this content.

In your code, if the next thing you were going to is copy the entire row, take off the select and immediately copy the entire row:

Please Login or Register  to view this content.

[JBeaucaire]

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.

[poppypoppy]

just did thanks

If that takes care of your need, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED.