Resolve: In VBA, How to insert a row without selecting the sheet

[mtheriault2000]

Hello

Amateur question, but maybe I'm to tire

From VBA, I want to insert a directly row on a sheet without previously selecting the sheet. How can I do that?

My code that doen't work:

 Sheets("List_ZoneOfInterest").Row("2:2").Insert Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove

Martin

Found the solution

  Sheets("List_ZoneOfInterest").Range("A2").EntireRow.Insert

 

[VoG]

Re: In VBA, How to insert a row without selecting the sheet

Try

Sheets("List_ZoneOfInterest").Rows("2:2").Insert Shift:=xlShiftDown, CopyOrigin:=xlFormatFromLeftOrAbove