Hi guys,
Hopefully this is a quick answer.
I have a range of values in column I starting from I2.
I usually select all on this column, right click, select Properties, and apply a Custom format of dd:hh:mm
Is there any way i can create a small piece of VBA to add to my existing code.
For example,
Thanks
Hopefully this is a quick answer.
I have a range of values in column I starting from I2.
I usually select all on this column, right click, select Properties, and apply a Custom format of dd:hh:mm
Is there any way i can create a small piece of VBA to add to my existing code.
For example,
Code:
Range("I2").Resize(LastRow - 1) = "=DATEVALUE(dd:hh:mm)"
Thanks