Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows
I have a macro which deletes a set of rows, but once the delete is done, I
need the curser to shift right by i cell. Problem is when you delete rows you do not have just one active cell selected. 2. is there any way to ensure the macro does not run if an entire row (or rows) is not selectee ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows
On Apr 15, 4:10*am, ordnance1
wrote: I have a macro which deletes a set of rows, but once the delete is done, I need the curser to shift right by i cell. Problem is when you delete rows you do not have just one active cell selected. 2. is there any way to ensure the macro does not run if an entire row (or rows) is not selectee ? Hello, The problem is not very clear from your post. Could you please post the code also? Regards Anant |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows
You don't need to select rows to delete them.
ActiveSheet.Range("A1:A56").EntireRow.Delete Post your code for more assistance. Easy enough to offset from the activecell if we knew where you wanted it. Gord Dibben MS Excel MVP On Mon, 14 Apr 2008 16:10:01 -0700, ordnance1 wrote: I have a macro which deletes a set of rows, but once the delete is done, I need the curser to shift right by i cell. Problem is when you delete rows you do not have just one active cell selected. 2. is there any way to ensure the macro does not run if an entire row (or rows) is not selectee ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows
I assume you want it one cell to the right of where you currently see it when
the macro is finished. If that is the case then insert this line just before the End Sub. ActiveCell.Offset(0, 1).Select That will move the cursor one cell to the right of the active cell. If this is not what you need then do as Anant suggested and post the macro you are using so we can see where the cursor action is. "ordnance1" wrote: I have a macro which deletes a set of rows, but once the delete is done, I need the curser to shift right by i cell. Problem is when you delete rows you do not have just one active cell selected. 2. is there any way to ensure the macro does not run if an entire row (or rows) is not selectee ? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows
Thanks for the reply.
The user will have to select the rows since they will not always be the me. So my problem is that when you select a set of rows to delete, once they are deleted you end up with a like number of rows still selected. So if you select rows 5,6 and 7 for deletion, once they are deleted rows 5, 6 and 7 are still selected soif you use ActiveCell.Offset(0, 1).Select you get an error because there is no active cell selected. "JLGWhiz" wrote: I assume you want it one cell to the right of where you currently see it when the macro is finished. If that is the case then insert this line just before the End Sub. ActiveCell.Offset(0, 1).Select That will move the cursor one cell to the right of the active cell. If this is not what you need then do as Anant suggested and post the macro you are using so we can see where the cursor action is. "ordnance1" wrote: I have a macro which deletes a set of rows, but once the delete is done, I need the curser to shift right by i cell. Problem is when you delete rows you do not have just one active cell selected. 2. is there any way to ensure the macro does not run if an entire row (or rows) is not selectee ? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows
Selection.Delete Shift:=xlUp
The user will have to select the rows since they will not always be the me. So my problem is that when you select a set of rows to delete, once they are deleted you end up with a like number of rows still selected. So if you select rows 5,6 and 7 for deletion, once they are deleted rows 5, 6 and 7 are still selected soif you use ActiveCell.Offset(0, 1).Select you get an error because there is no active cell selected. "Gord Dibben" wrote: You don't need to select rows to delete them. ActiveSheet.Range("A1:A56").EntireRow.Delete Post your code for more assistance. Easy enough to offset from the activecell if we knew where you wanted it. Gord Dibben MS Excel MVP On Mon, 14 Apr 2008 16:10:01 -0700, ordnance1 wrote: I have a macro which deletes a set of rows, but once the delete is done, I need the curser to shift right by i cell. Problem is when you delete rows you do not have just one active cell selected. 2. is there any way to ensure the macro does not run if an entire row (or rows) is not selectee ? |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting rows
There has to be an active cell no matter if you have 20 rows selected.
Active cell will be top left cell in selection. i.e. select row headers 1:15. You will see that A1 is the active cell EditDeleteEntire Row A1 is still the active cell. ActiveCell.Offset(0, 1) is B1 Select G1:K23 and EditDeleteEntire Row G1 will be the active cell. Gord On Mon, 14 Apr 2008 17:14:01 -0700, ordnance1 wrote: Selection.Delete Shift:=xlUp The user will have to select the rows since they will not always be the me. So my problem is that when you select a set of rows to delete, once they are deleted you end up with a like number of rows still selected. So if you select rows 5,6 and 7 for deletion, once they are deleted rows 5, 6 and 7 are still selected soif you use ActiveCell.Offset(0, 1).Select you get an error because there is no active cell selected. "Gord Dibben" wrote: You don't need to select rows to delete them. ActiveSheet.Range("A1:A56").EntireRow.Delete Post your code for more assistance. Easy enough to offset from the activecell if we knew where you wanted it. Gord Dibben MS Excel MVP On Mon, 14 Apr 2008 16:10:01 -0700, ordnance1 wrote: I have a macro which deletes a set of rows, but once the delete is done, I need the curser to shift right by i cell. Problem is when you delete rows you do not have just one active cell selected. 2. is there any way to ensure the macro does not run if an entire row (or rows) is not selectee ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions |