View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
joel joel is offline
external usenet poster
 
Posts: 9,101
Default Find a Number and Date - VBA

There is one change if forgot

from
if int(cell) = int(AppDate) then
to
if int(cell) = int(datevalue(AppDate)) then

I made the mistake of comparing a string again a date-serial-number

" wrote:

Thank you for responding, I'll try your suggestions. Much appreciated!