ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   how do you get (end down) to work in a macro? (https://www.excelbanter.com/excel-worksheet-functions/19035-how-do-you-get-end-down-work-macro.html)

lcx2

how do you get (end down) to work in a macro?
 
end down does not work the same in a macro as id does outside of a macro.

Bob Phillips

Do you mean

rng.End(xlDown).Select

for example?

If so, what is the difference?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"lcx2" wrote in message
...
end down does not work the same in a macro as id does outside of a macro.





All times are GMT +1. The time now is 12:15 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com