RalphA said:just_jon:
Hmm, "...a Long can be from -2,145,483,648 to 2,147,483,647". But, since in Excel spreadsheets I can write the number 214,784,836,481,234, which has 15 digits, versus the above long integers, with only 10 digits, why use long integers at all, since Excel provides 15 integers already?
Sub DataTypes()
MsgBox "The active cell is data type " & _
UCase(TypeName(ActiveCell.Value))
End Sub
Dear All,
I tried to use the functions roundup and rounddown in VBA but it does not work.
In a spreadsheet they do but not in VBA.
Can't find help in HELP.
Anybody that can help?
Lima Mike