Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a problem in a macro where I'm comparing two values. They appear to
be the same but when tested in the code, are different. I recreated the problem using this scenario: A1-D1 = .2003, .0542, .0257 and 0, respectively. A2-D2 have the same values. E1 = .2802 E2 = the formula sum(A2:D2) When I run the following code I get the message box values ".2802", ".2802" and "False". The funny thing is...if I type a formula in the worksheet =E1=E2 I get "True": Sub testit() frst = Range("E1").Value Scnd = Range("E2").Value MsgBox frst MsgBox Scnd MsgBox (frst = Scnd) End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Compare values on sheet 1 to values on sheet2 | Excel Worksheet Functions | |||
compare values | Excel Worksheet Functions | |||
compare a few values | Excel Discussion (Misc queries) | |||
Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) |