View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Justin H Justin H is offline
external usenet poster
 
Posts: 9
Default Insert # of Rows determined by cell

Hey Dave, Thanks for the help.

I copied the code you gave and changed the ("sheet1") to my sheet and I
assume that was all I had to change. You were correct that I do have headers
in Row 1 so I left FirstRow=2.

Everything else looked right, but when I compiled the code it highlighted
the 3rd to last line.
..Rows(iRow +1).Resize(HowMany).Insert HowMany

I haven't used most of the code before, is this just a () or something else?

Thanks Again!