Worksheet Change error

[samdegg]

Hello,

I am using this code:

Please Login or Register  to view this content.

And I getting a invalid use of property error, highlighting the first line of the code.

I have tried a number of times but as my VBA knowledge is limited, i have hit a brick wall.

[nilem]

Hi samdegg,
try this

Please Login or Register  to view this content.

[samdegg]

Sorry for the late reply. That is brilliant, thank you very much.