| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows after used cell?
Good day,
I have a spreadsheet where I need to delete all the rows after the last used cell in column B. How can I do this in a macro? TIA |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete rows after used cell?
One way:
With Cells(Rows.Count, 2) Range(.End(xlUp).Offset(1, 0), .Cells).EntireRow.Delete End With In article <Eh_nb.59258$Tr4.139820@attbi_s03, "JayL." wrote: Good day, I have a spreadsheet where I need to delete all the rows after the last used cell in column B. How can I do this in a macro? TIA |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete rows on Cell | Excel Discussion (Misc queries) | |||
| To delete rows when more than one cell is blank | Excel Worksheet Functions | |||
| Delete empty rows with cell type 2 | Excel Discussion (Misc queries) | |||
| Delete Rows below a certain cell | Excel Programming | |||
| Delete Rows with letter #VALUE in cell J | Excel Programming | |||
Hybrid Mode
