nitrammada
Board Regular
- Joined
- Oct 10, 2018
- Messages
- 78
- Office Version
- 365
- Platform
- Windows
Hi Everyone,
On Worksheet Change I'm using the intersect method of a range and target address to run my code if cells within the range are changed.
I found this in the FAQ's (many thanks) and it works fine. My challenge is, and this is where I need help, I have many sheets within my workbook that all have exactly the same layout and all have exactly the same range that, if changed, requires a macro to run.
Can anyone help me as to how I can get my macro to run on any one of these sheets should it be changed within the specified range? Some thing that may help, is that out of the many sheets contained within the Workbook, the sheets that require the macro to run, all have 'L2' in cell A1. I figure this might assist as an index to identify the sheets the require the macro to run on change. And it will only be required to run when the sheet is active.
Any help would be appreciated.
Thanks in advance
Adam
On Worksheet Change I'm using the intersect method of a range and target address to run my code if cells within the range are changed.
I found this in the FAQ's (many thanks) and it works fine. My challenge is, and this is where I need help, I have many sheets within my workbook that all have exactly the same layout and all have exactly the same range that, if changed, requires a macro to run.
Can anyone help me as to how I can get my macro to run on any one of these sheets should it be changed within the specified range? Some thing that may help, is that out of the many sheets contained within the Workbook, the sheets that require the macro to run, all have 'L2' in cell A1. I figure this might assist as an index to identify the sheets the require the macro to run on change. And it will only be required to run when the sheet is active.
Any help would be appreciated.
Thanks in advance
Adam