To assign space for an Excel (2003) column that required maximum 5
characters, I declared it as Dim strCompound String * 5.
But I do not know how to fit specific requirements for my designated
calculation fields (I have no VBA help file to lookup!!!):

- Declare a variable that has maximum 8 digits and 4 decimals (i.e.:
42352975.3687).

- Declare a variable with currency value that has maximum of 6 digits
and 2 decimals ( i.e.: $234567.25)

I began to use macro since last month and do not know if there is a
way to meet the needs for those columns. Please show me the rope if
possible. Thank you. James