Jan 14 2021 08:13 AM - edited Jan 15 2021 09:41 AM
Jan 14 2021 08:58 AM
VBA uses straight quotes "...", not French quotes. So:
If Target.Address(False, False) = "E15" Then
Jan 14 2021 10:00 AM
Jan 14 2021 10:13 AM
Click in the line
Private Sub Worksheet_Change(ByVal Target As Range)
and press F9 to set a breakpoint.
Change cell E15 and press Enter.
The code will pause at the above line.
You can press F8 repeatedly to execute the code line by line.
Does that provide a clue?
Jan 14 2021 10:31 AM
Jan 14 2021 10:32 AM
Jan 14 2021 10:36 AM
Jan 14 2021 11:04 AM
Could you attach a copy of the workbook (without sensitive information)?
Jan 15 2021 02:49 AM - edited Jan 15 2021 09:42 AM
My code is
Jan 15 2021 06:04 AM
We're not getting any further. Perhaps someone else can help you.