Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i delete all the rows lying below a cell.
I have a file that i get from client. On a daily basis, I have to
delete all the rows after the last value on the file. Means: if the last number ends at B25, i will select all the rows from from 26 till the end (like..65,500th row or whatever is the last) and then delete everything. Although these rows are empty, i still have to delete those in order to print only till B25. How can i create a macro that will look for the last value and delete all the rows lying below that (till the end).? Please note that, it is not B25 all the time. It might end at D10 or B15. anywhere. So this macro should check for values which is at the most bottom of any columns. Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do i delete all the rows lying below a cell.
Have a look here for ways to do it,
http://www.mvps.org/dmcritchie/excel/lastcell.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "VB Script for Excel" wrote in message oups.com... I have a file that i get from client. On a daily basis, I have to delete all the rows after the last value on the file. Means: if the last number ends at B25, i will select all the rows from from 26 till the end (like..65,500th row or whatever is the last) and then delete everything. Although these rows are empty, i still have to delete those in order to print only till B25. How can i create a macro that will look for the last value and delete all the rows lying below that (till the end).? Please note that, it is not B25 all the time. It might end at D10 or B15. anywhere. So this macro should check for values which is at the most bottom of any columns. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete rows on Cell | Excel Discussion (Misc queries) | |||
Why is XL lying to me?? | Excel Worksheet Functions | |||
delete all rows above a selected cell | Excel Programming | |||
Delete rows after used cell? | Excel Programming | |||
Delete Rows below a certain cell | Excel Programming |