Dim a Decimal

[gmccreedy]

how come this feature is not available? How do I DIM a decimal? As a Variant?

[norie]

Try Double or Single.

[royUK]

Try this

Option Explicit 
 
Sub test() 
    Dim x As Double 
    x = 5 / 2 
    MsgBox x 
End Sub 

[gmccreedy]

thank you fine sirs worked great

(just working up that beer count aren't you Roy...)

[royUK]

You will never set foot in the UK I suspect, you will have to buy a brewery.