If it's your macro, have it delete row 65535 (one up from the bottom), then
insert the row.

But look at the file size before you add the space character to A65536 and
after. It might not be important.

"mika." wrote:

That is very cool, thank you! Unfortunately,the macro I
want to run when the user tries to insert a row also needs
to insert a row (it just does so conditionally). Any
other suggestions?

-----Original Message-----
Maybe a naughty quickfix, but effective:
if you want to prevent the user from inserting a row,
type
a [space] in cell A65536
greetings,
Derek


-----Original Message-----
in VBA, I would like to do the following:

If the user tries to insert a row
'run another macro i have instead

Could someone give me a lead on how i might detect if
they
are inserting a row or not?

Thanks.
.

.


--

Dave Peterson