View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default Command button code

Hi Gary,

To insert the row(s) in the active sheet, change:

SH.Range("A10").Resize(10).EntireRow.Insert


to

Me.Range("A10").Resize(10).EntireRow.Insert

Change the location for the insertion and the number of
rows to be inserted to accord with your requirements.



---
Regards,
Norman