Ago
04-03-2013, 10:15 AM
I try to get the Value of Column R as in the macro shows with the decimals.
Is that even possible?
Sub bbbasd()
MsgBox Format((Range("R365").Value), "nn:ss:00")
End Sub
It "works" in Excel but not in VBA.
I have tried str(), Timevalue and just Range(), but none of them seems to work.
Any ideas?
Is that even possible?
Sub bbbasd()
MsgBox Format((Range("R365").Value), "nn:ss:00")
End Sub
It "works" in Excel but not in VBA.
I have tried str(), Timevalue and just Range(), but none of them seems to work.
Any ideas?