Converting km/h to m/s

[dslt]

Heys, How would you write a VBA code to convert Km/h to m/s? in two different cells?

Thanks for any help

 

[VoG]

Why do you need VBA?

Excel Workbook
	A	B
1	km/h	m/s
2	85	23.61111
Sheet11

 

[dslt]

I need it to use it as part of my sub program that i am developing

 

[FishingIsMoreFun]

Divide Km/h by 3600 *1000 = m/s

 

[VoG]

Try like this

Range("B2").Value = Range("A2").Value * 1000 / 3600

 

[dslt]

Heys VoG, how can I change that code if i have more values in the column of A2, the range?

Thanks for your help by the way !

 

[VoG]

Try like this

Sub test()
Dim LR As Long
LR = Range("A" & Rows.Count).End(xlUp).Row
For i = 2 To LR
    Range("B" & i).Value = Range("A" & i).Value * 1000 / 3600
Next i
End Sub