View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Jenkins[_2_] David Jenkins[_2_] is offline
external usenet poster
 
Posts: 6
Default 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