View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt[_3_] Barb Reinhardt[_3_] is offline
external usenet poster
 
Posts: 1
Default Function to return column where a date is entered

I'd like to have a function something like this:

Function FindDateColumn(myWS as worksheet, myDate as Date)

I want to find the first (and probably only entry) of a specific date on a
worksheet and return the date column. I can't seem to get it to return
anything. I'd show my code, but unfortunately, it's at work and I"m not.
It seems to be format specific somehow. Can someone help?

Thanks,
Barb Reinhardt