IF Statement

Hi all

I have a Piece of code that works when a cell changes its value.

I want to try and get it to work when only cells in coloumn B change

I thought the best way would be with using an IF statement but i am unsure on the code to write and get it to work.

This is the code that i have at the moment.

Please Login or Register  to view this content.

I want to add in at the start an IF statement that IF the Target Cell is in Coloumn B then Carry on Else Exit Sub.

Any Help with the code or a way in doing this will be great.

Thanks

Tom

Please take a few minutes to re-read the forum rules, and then edit your post to add code tags.

Thanks.

Hey

Sorry Didnt Know About the Code Quotes. Changed Now,

Not To Worry I have Sorted it Out now anyway.

Have Done it like this is anyone else was interested.

Please Login or Register  to view this content.

Thanks

Tom

Spot on. You can also add it into the existing statement:

Please Login or Register  to view this content.