View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.programming
baconcow baconcow is offline
external usenet poster
 
Posts: 45
Default Insert a Row - Variable Location

Thank you! It worked. I had tried it without the Range, but, that was before
I tried using ActiveCell as well. I had everything you see here, except the
"EntireRow" portion. Now, with the EntireRow portion, it seems to work.
Thanks again!!!

cell_range.Offset(cell_count + 2).EntireRow.Insert _
Shift:=xlDown, CopyOrigin:=xlFormatFromLeftOrAbove