I keep getting a syntax erring in my code?

Please Login or Register  to view this content.

I keep getting a syntax erro for this code please help.

This should be 2 separate lines, rather than 1. So remove the appeand and continuation character

Please Login or Register  to view this content.

The routine looks like an event routine, so you should not really be changing the Target variable reference.

if you want to run the code when D1 changes then

Please Login or Register  to view this content.

If you want it to run whenever a cell changes then remove the 2 IF commands and their matching End If