simple operation on a range

[silkworth]

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:

Rng.Value = Rng.Value / 3.6

(And Rng is created using Set.)

That causes a type mismatch. What am I doing wrong?

Thanks

 

[lenze]

Dim cl as Range
For Each cl in Rng
cl = cl/3.6
Next cl

lenze

 

[foxguy]

I interpret this to mean that Rng.Value is not numeric. Maybe it's text that looks like a number.
Try

Rng.Value = Value(Rng.Value)/3.6

 

[Richard Schollar]

Another way:

rng.Value = Evaluate(rng.Address & "/3.6")