Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
comparing values in excel with vb6
I am writing a macro that compares a date and time in
worksheetA with with a date and time in worksheetB. The date and time are in separate columns. The time is calculated in worksheetB from a text value (0500) imported from a Data Base with the formula =value(left(d7,2)/24 In worksheetA the time value is calculated with the formula =5/24. I do a comparison to determine if these values are equal in excel by the formula =worksheetA!b7=worksheetB!b8 and recieve a true return. The same two cells in vb do not compare equally in an if statement and go to an else statement the says worksheetA!b7 < worksheetB!b8. I have tried copying the value of one cell to the other without and change in result. Any suggestions. Thanks in advance for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with Comparing values and retrieving values in Excel!!!!!! | Excel Worksheet Functions | |||
Comparing values between columns only when there are values in bot | Excel Worksheet Functions | |||
Comparing a value to a list of values does not work in Excel 2003. | Excel Worksheet Functions | |||
comparing two values | Excel Worksheet Functions | |||
Excel Comparing Values | Excel Discussion (Misc queries) |