Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Capturing Top 5 Performers | Excel Worksheet Functions | |||
capturing all of the data | Excel Worksheet Functions | |||
Capturing Date | New Users to Excel | |||
Capturing an Error | Excel Programming | |||
Capturing user name | Excel Programming |