Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Value Issue
Hi All, I have a value in cell A1. The format of cell is General. Now using a function I am checking if the value is = 0.35 like below... sub test() Dim TestValue as double TestValue=Range("A2").VALUE If TestValue = 0.35 then msgbox "Yes" End if end sub The strange thing is when the value in the Cell A1 is 0.35 still the condition is not satsified. I checked the Value of the TestValue by putting the cusrson on it and 0.35. So when TestValue is 0.35 and condition is 0.35 then why don't the if does't work. I understand this is a little strange. Any help would be greatly appreciated. Thanks Ankur www.xlmacros.com |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I believe that this is a set up issue... | Setting up and Configuration of Excel | |||
SUM Issue.. HELP | Excel Discussion (Misc queries) | |||
Issue | Excel Discussion (Misc queries) | |||
For Next Issue | Excel Programming | |||
Issue with zero/# issue!! | Excel Worksheet Functions |