Capturing deletion of a row
 

How can I tell if a user has deleted a row?

I need to recal certain cells but only if the user has deleted one or more
rows. I have a macro in the SheetChange event that executes every time
there is a change to a worksheet. I need it to execute onloy if the user
has deleted a row.

Glen

Capturing deletion of a row
 

Unfortunately, there is no such event.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Glen Mettler" wrote in message
...
How can I tell if a user has deleted a row?

I need to recal certain cells but only if the user has deleted
one or more rows. I have a macro in the SheetChange event that
executes every time there is a change to a worksheet. I need
it to execute onloy if the user has deleted a row.

Glen

Capturing deletion of a row
 

Maybe store the counta( in a cell somewhere and have the event do an
immediate counta and react if the two don't match??

--
Don Guillett
SalesAid Software

"Glen Mettler" wrote in message
...
How can I tell if a user has deleted a row?

I need to recal certain cells but only if the user has deleted one or more
rows. I have a macro in the SheetChange event that executes every time
there is a change to a worksheet. I need it to execute onloy if the user
has deleted a row.

Glen

Capturing deletion of a row
 

Problem solved
I created a public variable RowCount
The in the ActivateSheet event I count the rows
RowCount=cells(rows.count,1).end(xlup).row

Then in the SheetChange event
I count the rows again and compare it to RowCount. If the user has added or
deleted a row I update RowCount and then run the recalc, otherwise I exit
the sub

Glen

"Glen Mettler" wrote in message
...
How can I tell if a user has deleted a row?

I need to recal certain cells but only if the user has deleted one or more
rows. I have a macro in the SheetChange event that executes every time
there is a change to a worksheet. I need it to execute onloy if the user
has deleted a row.

Glen