View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett[_4_] Don Guillett[_4_] is offline
external usenet poster
 
Posts: 2,337
Default 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