Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows to a defined point
I would like to delete all rows from row 7 to the row number of the range
LastLine, which refers to a single cell. Any suggestions? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows to a defined point
Range(Range("A7"), Range("lastline")).EntireRow.Delete
"Tim Green" wrote: I would like to delete all rows from row 7 to the row number of the range LastLine, which refers to a single cell. Any suggestions? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows to a defined point
Thanks!
"Martin" wrote: Range(Range("A7"), Range("lastline")).EntireRow.Delete "Tim Green" wrote: I would like to delete all rows from row 7 to the row number of the range LastLine, which refers to a single cell. Any suggestions? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to add rows, to point to new row | Excel Discussion (Misc queries) | |||
defined cell as currency but still have to enter decimal point | Excel Worksheet Functions | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
auto deleting defined rows | Excel Discussion (Misc queries) | |||
Deleting unused Defined Names in a workbook? | Excel Programming |