Intersect on two columns to copy current date when data input

Hi,

Can anyone explain why the below code will not work for multiple columns? When I change the column from only 'B' to multiple columns for some reason it doesn't work & I can't figure out why (I'm sure it's something simple) :/

Please Login or Register  to view this content.

Thanks guys!

If you simply want the date to be placed to the right of the data you enter in Columns B and S, this code should do it.

Please Login or Register  to view this content.

I need the date entering in column C next to each cell that data is copied over via a macro into column B. The above code works fine and enters the date in only column C but I now require it to do the same for column S also when data is copied into column T.

How about this?

Please Login or Register  to view this content.

This appears to give a 'Type mismatch' here....

Please Login or Register  to view this content.

Any idea why?

I'm not sure why. It worked for me in a dummy sheet. Open the attachment below. Type anything in column B and column T and the date will appear. If you are still encountering problems, post a copy of your file so that I can have a closer look.