Hi All,
I'm trying figure out how to quickly alter each value in the cells of a range, ie convert from km/h to m/s, and I could swear that I could just do this and it worked in the past, but now it doesn't:
(And Rng is created using Set.)
That causes a type mismatch. What am I doing wrong?
Thanks
I'm trying figure out how to quickly alter each value in the cells of a range, ie convert from km/h to m/s, and I could swear that I could just do this and it worked in the past, but now it doesn't:
Code:
Rng.Value = Rng.Value / 3.6
(And Rng is created using Set.)
That causes a type mismatch. What am I doing wrong?
Thanks