Worksheet testing?

[RustyNail]

Hello,

I need to execute a piece of code only when the user modifies certain columns. However
I noticed that the code runs also when those same columns across all my other worksheets get modified!!!

So I tried putting an "if" statement before the code in question so to identify if the columns that the user modifies are actually in the correct worksheet.

Here is the code:

Please Login or Register  to view this content.

However at the line where I test if the current worksheet is "Main" I get an error

Does anyone know how we can test for the current worksheet name with an "if" statement?

Thank you for your help

RN

[xladept]

Try:

Please Login or Register  to view this content.

[Roel Jongman]

if you only want to run the code one 1 sheet, would it not make more sense to then put the code in the worksheet module using the worksheet_activate event instead of Thisworkbook module as it is now..

[bakerman2]

Please Login or Register  to view this content.