ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Last Row Utility (https://www.excelbanter.com/excel-programming/320116-last-row-utility.html)

Dthmtlgod[_3_]

Last Row Utility
 
I remember seeing something on this, when you hit CTRL END, you will see the
true last cell used. Where is the function/utility to remove the erroneous
rows.

Thanks,
Doug




Tom Ogilvy

Last Row Utility
 
See Debra Dalgleish's site

http://www.contextures.com/tiptech.html

see Used Range, Reset (FAQ)
under T-Z

--
Regards,
Tom Ogilvy


"Dthmtlgod" wrote in message
...
I remember seeing something on this, when you hit CTRL END, you will see

the
true last cell used. Where is the function/utility to remove the

erroneous
rows.

Thanks,
Doug






Ed

Last Row Utility
 
Doug:

Try these and see if they help:
http://www.mvps.org/dmcritchie/excel...m#makelastcell

http://www.contextures.com/xlfaqApp.html#Unused



Ed



"Dthmtlgod" wrote in message
...
I remember seeing something on this, when you hit CTRL END, you will see

the
true last cell used. Where is the function/utility to remove the

erroneous
rows.

Thanks,
Doug







All times are GMT +1. The time now is 11:58 PM.

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