Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I am having trouble writing a variable (defined as a
single) from a macro into a given cell. I have several subtotals (Billing by dept) in the macro that are numbers (2 decimals). When I write these numbers to a cell in a new worksheet, any odd decimals (Not .25, .50, .75) are changed slightly (Ex: 100.06 becomes 100.059997558593). I think this is because they are entered as a variant. There's probably an easy fix, but I can't find anything in the help files. Thanks in advance! Parker |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
writing an formulae with variable parameters | Excel Worksheet Functions | |||
Writing a macro to hide columns based on cell value | Excel Discussion (Misc queries) | |||
writing a variable to a cell | Excel Programming | |||
writing a variable to a cell | Excel Programming |