Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Does anyone know the appropriate syntax to delete a row or rows when it is
cut to a new destination? I'm sure this can be done in a single line of code, but I can't crack it. My code line so far looks like the following, but of course it leaves blank rows behind that I want removed as it is cut: Cells(lngX, 1).EntireRow.Cut Destination:=Sheets(FUTURE.Name).Range("A65536").E nd(xlUp).Offset(1, 0) Thanks much in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Hpw do I delete multiple empty rows found between filled rows? | Excel Worksheet Functions | |||
How to Delete empty rows in excel in b/w rows with values | Excel Worksheet Functions | |||
Cut filtered rows, paste into next empty row of new sheet, and delete cut rows | Excel Worksheet Functions | |||
How to delete rows when List toolbar's "delete" isnt highlighted? | Excel Worksheet Functions | |||
Delete every 3rd row, then delete rows 2-7, move info f/every 2nd row up one to the end and delete the row below | Excel Programming |