Insert a Row - Variable Location
How come this code fails?
' insert row
Range(cell_range.Offset(cell_count + 2)).Select
ActiveCell.Offset(1).EntireRow.Insert _
Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove
It says "Method 'Range' of object '_Worksheet' failed?
Please, any help. I just want to insert a row underneath the one in the
active cell.
|