Something like:

With ActiveCell
If .Row = 18 And .Row <=80 Then .EntireRow.Insert
End With

--

Vasant




"CoronaSTX" wrote
in message ...

How would I create a command button to insert a row only in a certain
range of cells or lets say only between A19 and A80 a user could insert
a row but not before or A19 or after A80. Again thanks for any help.


--
CoronaSTX
------------------------------------------------------------------------
CoronaSTX's Profile:
http://www.excelforum.com/member.php...o&userid=27958
View this thread: http://www.excelforum.com/showthread...hreadid=474581