for archival purposes, you should post your final solution.

--
Don Guillett
SalesAid Software

"Darren" wrote in message
...
The suggestions work fine

thanks for the help
--
Darren


"Darren" wrote:

In cell A1 I have a date in the format of DD/MM/YYYY. I want to be able
to
extract the month and from that run a macro based on that months value

eg If january run macro january
if febuary run macro febuary
and so on until december

any suggestions on how I do this.

Thanks
--
Darren