| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete rows from activecell
Hi All,
I know this is a simple one, but i've been trying to figure out how to delete the next ten rows from the activecell, using a minimum amount of coding. I.e. in 1 line. The delete method should shift lines up. I've tried stuff like : Rows.[R:R[10]].Delete thinking of using the R1C1 format, but that doesn't work Can anyone give a few hints? Cheers, Al. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete rows from activecell
RANGE(ACTIVECELL.Offset(1),ACTIVECELL.Offset(10)). Delete
SHIFT:=XLUP rgds Rog -----Original Message----- Hi All, I know this is a simple one, but i've been trying to figure out how to delete the next ten rows from the activecell, using a minimum amount of coding. I.e. in 1 line. The delete method should shift lines up. I've tried stuff like : Rows.[R:R[10]].Delete thinking of using the R1C1 format, but that doesn't work Can anyone give a few hints? Cheers, Al. . |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete rows from activecell
Cheers Rog,
That helps heaps. Al. "Rog" wrote in message ... RANGE(ACTIVECELL.Offset(1),ACTIVECELL.Offset(10)). Delete SHIFT:=XLUP rgds Rog -----Original Message----- Hi All, I know this is a simple one, but i've been trying to figure out how to delete the next ten rows from the activecell, using a minimum amount of coding. I.e. in 1 line. The delete method should shift lines up. I've tried stuff like : Rows.[R:R[10]].Delete thinking of using the R1C1 format, but that doesn't work Can anyone give a few hints? Cheers, Al. . |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Delete rows from activecell
Another
ActiveCell.Offset(1,0).Resize(10).EntireRow.Delete -- Regards, Tom Ogilvy "al" wrote in message ... Cheers Rog, That helps heaps. Al. "Rog" wrote in message ... RANGE(ACTIVECELL.Offset(1),ACTIVECELL.Offset(10)). Delete SHIFT:=XLUP rgds Rog -----Original Message----- Hi All, I know this is a simple one, but i've been trying to figure out how to delete the next ten rows from the activecell, using a minimum amount of coding. I.e. in 1 line. The delete method should shift lines up. I've tried stuff like : Rows.[R:R[10]].Delete thinking of using the R1C1 format, but that doesn't work Can anyone give a few hints? Cheers, Al. . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need Help with ActiveCell.EntireRow.Delete | Excel Discussion (Misc queries) | |||
| Need Help with ActiveCell.EntireRow.Delete | Excel Discussion (Misc queries) | |||
| If activecell.column = variable then activecell,offset (0,1) | Excel Discussion (Misc queries) | |||
| 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 | |||
| Delete the row where the activecell is located with VBA | Excel Programming | |||
Linear Mode
