Compile Error Ambiguous name detected worksheet_change

[OwnDizzzld]

So im using this code to create time stamps

Code:

Please Login or Register  to view this content.

However I want to repeat this with column N and O

I tried to create my own code in notepad, This is what i came up with

Code:

Please Login or Register  to view this content.

However its coming up with "Compile Error Ambiguous name detected worksheet_change"

what am i doing wrong ?

[Olly]

Do you have two identically named (worksheet_change) subroutines in the same worksheet module?

[Norie]

Try this.

Please Login or Register  to view this content.

[Kaper]

HAve you replaced or added new procedure?

Old citation: "There can be only one" ;-) applies here - in one sheet module you cannot have two Worksheet_Change (ora ny other two with the same name) procedures.


PS. Columns N and O are rather 14 and 15th, but I think the problem is as described above - two procedures with the same name in one module.

[OwnDizzzld]

Ok so I ended up doing this.

Please Login or Register  to view this content.

Thank you everyone for your suggestions

[Kaper]

How about possible extensions for further columns?
They are spaced quite regular in your sheet, so may be the following is worth considering:

Please Login or Register  to view this content.

[Norie]

The code I posted will work for columns J and N, it can be adapted if you need it to work for other columns.

Something like this perhaps.

Please Login or Register  to view this content.

By the way, I've used 38 in the code as that's the column number of column AL.

[Olly]

Another potentially useful approach is to select the case of the column number:

Please Login or Register  to view this content.