Cells update on change. - Help.

[RandomPezzer]

HI Guys,
In column T the cells will change between a few different text values, and up on change column W updates with the date.

for example: I update cell T6 = Yes then cell W6 = date

Ive been using this code which works fine on Excel 2010 at home, but when using on Excel 2013 at work the cells don't update or do anything. Can someone have a look at the code to see where i'm going wrong.

Please Login or Register  to view this content.

Thanks

[6StringJazzer]

There is little or nothing that should make a difference between VBA in 2010 and 2013. There could be some other difference--for example, do you have 32-bit Office on one machine and 64-bit on another?

I would make two changes. For

Application.ActiveSheet.Range("T:T")

use

Range("T:T")

and for

VBA.IsEmpty(rng.Value)

use

IsEmpty(rng.Value)

I am not sure these are wrong but it's unnecessary to use those qualifications and cleaning that up might help us to figure out what's wrong.

[RandomPezzer]

Thanks for the advice 6StringJazzer, the above code worked!