I'm pretty sure this will do what you want...

Checkrow = 4
AddRow = 2
Rows(CheckRow + 1).Resize(AddRow).Insert Shift:=xlShiftDown

--
Rick (MVP - Excel)


"Bishop" wrote in message
...
I'm in a With statement and I'm trying to select one more rows depending
on
the value of my variables. For example, say
Checkrow = 4
AddRow = 2
I want to insert 2 rows below row 4 this is what I'm trying:
.Rows((CheckRow + 1):(CheckRow + 1 + AddRow - 1)).Select
Selection.Insert Shift:=xlDown
This would be the same as:
Rows("3:4").Select
Selection.Insert Shift:=xlDown
but I'm getting a compile error: expected list separator or )

How do I make this work?