|
|
#2
09-10-2015, 12:11 AM
|
||||
|
||||
If your reference cells contain actual dates and you're concerned to match those containing 30/6/2015, you will need to test the numeric value of that date (42185), not its formatted representation.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Clearing format and its effect on background color or a range, Excel 2010 | Aria | Excel | 0 | 11-03-2014 11:21 PM |
 #REF! Error in calling VBA function disappears when function is copied
|
lcaretto | Excel Programming | 2 | 05-26-2014 07:19 PM |
|
Find and Replace function shooting off screen to the left of the document
|
Mattblack | Word | 1 | 04-10-2014 03:06 PM |
| Converting a left to right doc to a right to left | seli | Word | 3 | 04-23-2012 11:39 PM |
| Change format of date when using Now function in VB code | Bondai | Excel Programming | 2 | 03-02-2012 05:09 PM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode