As I said, it works for me, but my client in India is still receiving the error message "Date not found".

Column A was formatted as mm/dd/yyyy, in a format that will adjust to her computer settings, and the line sDate = Format(Now, "dd/mm/yy") was changed to sDate = Date.

Any other suggestions? She is going to contact her computer "guy", but I don't know how familiar he is with VBA, if at all.

Gratefully,
Susan :)


On Monday, December 24, 2012 2:04:14 PM UTC-5, Susan wrote:
Ok, works for me, let's see if it works for my client! I'll let you know.

Thanks!

Susan :)





On Sunday, December 23, 2012 4:09:48 AM UTC-5, Claus Busch wrote:

Hi susan,







Am Sat, 22 Dec 2012 13:54:07 -0800 (PST) schrieb Susan:







Public sDate as Date







doesn't work. It says it can't find the date. sDate as String worked



(on my computer).







what I meant is to change



sDate = Format(Now, "dd/mm/yy")



to



sDate =Date











Regards



Claus Busch



--



Win XP PRof SP2 / Vista Ultimate SP2



Office 2003 SP2 /2007 Ultimate SP2