Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Could anyone help with a Macro to delete a row.
My spreadsheet contains infomation that I review and then 'cut' the data from one worksheet and paste it in a new worksheet. One of several different ones actually This leaves a blank row in the original worksheet. The code I use for this is ActiveCell.EntireRow.Delete I cannot specify the row to delete in the code as the sheet is filtered so I would like to delete the row I have removed the data from and shift the remining data up. i.e. Rows.Delete Shift:=xlUp. The only problem with this code is the entire sheet gets deleted. I have tried ActiveRow and ActiveRows but VBA doesnt appear to recognize this. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
delete Macro | Excel Discussion (Misc queries) | |||
Cannot Delete Macro | New Users to Excel | |||
delete a macro that isn't in macro list | Excel Discussion (Misc queries) | |||
How can I delete a macro when the Delete button is not active? | Excel Worksheet Functions | |||
How do i delete a macro in Excel 2003 when delete isn't highlight | Excel Discussion (Misc queries) |