Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert Row without Selecting
I'd like to be able to insert a new row without having to
select a row first. This is the syntax I'm using (from a recorded macro): TargCell.EntireRow.Select Selection.Insert Shift:=xlDown I don't want to have to do a select because the sheet I'm manipulating is (windows(sheetname).visible = false), and currently I have to "unhide" it in order to insert the row, or I get an error trying to do the select when it's hidden. Any help would be appreciated. David Jenkins |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot insert worksheet in exel - not available in insert menu | Excel Worksheet Functions | |||
insert row / insert column command buttons | Excel Worksheet Functions | |||
Can I auto insert a worksheet when I insert a value in a cell. | Excel Worksheet Functions | |||
Insert Next? Or insert a variable number of records...how? | Excel Discussion (Misc queries) | |||
Selecting ALL names when using Insert/Names/Apply | Excel Worksheet Functions |