Thread: Can anyone help with the following macro?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ivan Raiminius Ivan Raiminius is offline
external usenet poster
  
Posts: 258
Default Can anyone help with the following macro?
Hi Stan,

Sub InsertRow()
intersect(range("B:B"),activesheet.usedrange).Spec ialCells(xlCellTypeBlanks).entirerow.insert
end sub

Regards,
Ivan

Reply With QuoteReply With Quote