View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] cjwenngatz@gmail.com[_2_] is offline
external usenet poster
 
Posts: 16
Default Function Problem.


We know that... but a "date" does not have a sheet reference... it is just a
date (actually, a number). Change your comparisons form this...

OC!I3:I9999<OC!Date(2007,6,6)

to this...

OC!I3:I9999<Date(2007,6,6)

Note there is no 'OC!' in front of the Date function, only in front of the
cell reference.

Rick


Thank you! I knew it was something like that, but I must have been
staring at it too long :S
Thanks again for the help!