Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Row Selection
Any one please help me.......?
After inserting row how can I go back to the row I selected for inserting, instead for going to A1 Sub insertrowatselection() Rows(ActiveCell.Row).Insert Range("A1").Select |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Row Selection
hi
not sure but see if this is what you want..... Sub insertrowatselection() Rows(ActiveCell.Row).Insert ActiveCell.Offset(1, 0).Select End Sub regards FSt1 " VLOOKUP fORMULA" wrote: Any one please help me.......? After inserting row how can I go back to the row I selected for inserting, instead for going to A1 Sub insertrowatselection() Rows(ActiveCell.Row).Insert Range("A1").Select |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Insert Row Selection
Hi,
here is another suggestion Sub MyInsert() With Selection .EntireRow.Insert .Select End With End Sub -- If this helps, please click the Yes button. Cheers, Shane Devenshire " VLOOKUP fORMULA" wrote: Any one please help me.......? After inserting row how can I go back to the row I selected for inserting, instead for going to A1 Sub insertrowatselection() Rows(ActiveCell.Row).Insert Range("A1").Select |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
Identifying a selection of a selection of a range | Excel Worksheet Functions | |||
Insert Picture from dropdown selection | New Users to Excel | |||
Truncated font list in Excel's "Insert Symbol" menu selection | Excel Discussion (Misc queries) | |||
limit cell list selection based on the selection of another list | Excel Worksheet Functions |