i understand but i am a novice to VB. Do i simply need to insert this or
create a click event??
"Rob van Gelder" wrote in message
...
Your request was an example for:
.
"cell A1 on sheet1 1, then insert 2 rows on sheet2 after a30"

That's what the code I supplied does.

--
Rob van Gelder - http://www.vangelder.co.nz/excel


"gav meredith" wrote in message
...
Thanks Rob! Is this all i need or is there another part of the code??

"Rob van Gelder" wrote in
message
...
Sub test()
If Worksheets("Sheet1").Range("A1").Value 1 Then
Worksheets("Sheet2").Range("31:32").Insert xlShiftDown
End If
End Sub


--
Rob van Gelder - http://www.vangelder.co.nz/excel


"gav meredith" wrote in message
...
Hi,

Based upon some type of selection method (check box, value 1, etc)
how
would i get excel to insert 2 rows?? ie: cell A1 on sheet1 1, then
insert
2 rows on sheet2 after a30.....any suggestions would be great!!!!