macro help
i have a row of cells that total other cells...i want to
initiate a macro if any cell in this row changes. any ideas? thanks for your help. |
Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo ws_exit: Application.EnableEvents = False If target.row= 1 Then With Target 'do your stuff End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "johnT" wrote in message ... i have a row of cells that total other cells...i want to initiate a macro if any cell in this row changes. any ideas? thanks for your help. |
cant get it to work, shouldnt this be calculation event?
-----Original Message----- Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If target.row= 1 Then With Target 'do your stuff End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "johnT" wrote in message ... i have a row of cells that total other cells...i want to initiate a macro if any cell in this row changes. any ideas? thanks for your help. . |
should clarify, using excel 97
-----Original Message----- cant get it to work, shouldnt this be calculation event? -----Original Message----- Private Sub Worksheet_Change(ByVal Target As Range) On Error GoTo ws_exit: Application.EnableEvents = False If target.row= 1 Then With Target 'do your stuff End With End If ws_exit: Application.EnableEvents = True End Sub 'This is worksheet event code, which means that it needs to be 'placed in the appropriate worksheet code module, not a standard 'code module. To do this, right-click on the sheet tab, select 'the View Code option from the menu, and paste the code in. -- HTH RP (remove nothere from the email address if mailing direct) "johnT" wrote in message ... i have a row of cells that total other cells...i want to initiate a macro if any cell in this row changes. any ideas? thanks for your help. . . |
All times are GMT +1. The time now is 07:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com