Thanks All!

Norman,

Cheers. I think this is what I was trying to do initially, and may eve
have stolen what I had from another posting of yours?! Anyway, I'v
tried it and it works - thanks! Although I've already put Tom's code i
so that will be staying in this instance, but I think I'll be able t
remember the weekdayname(weekday... function more easily.


Tom,

Thanks again! I get my date from a cell value but I must keep the cel
values in the dd/mm/yyyy format. This said, if this is ALWAYS the cas
will using my variable which contains the date in dd/mm/yyyy format b
okay as long as the worksheet cell values remain consistent?

My procedure is finished now, thanks to your help, and so I don't wan
to hog everybody's time but if it's going to fall over because of th
date format I obviously would like to know in advance and try to adjus
the code now?

Below is the code that passes the date to the variable:

Set Cobd = Rows(1).Find("closeofbusinessdate").Offset(1, 0)

Cheers.

Adria

--
Message posted from http://www.ExcelForum.com