Thread: Inserting blank rows
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
  
Posts: 2,824
Default Inserting blank rows
Dim n As Long
n = 5
Rows(n).Resize(2).Insert

ChuckM wrote:

How do insert 2 blank rows above row n. n is an integer

thanks
chuck

--

Dave Peterson

Reply With QuoteReply With Quote