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
|