Hi Gordon,

I also posted in the Microsoft.Public.Excel Group.

Got some good answers there too.
Main ones were
For VBA
HoldPrevYearDate = "Previous Year: " _
& Format(activeworkbook.worksheets("sheet99").range( "a1").value, "dd
mmm yyyy")
For Excel
HoldPrevYearDate = "Date Reported: "&TEXT(A1,"dd mmm yyyy")


Best Regards,

Steve Wilson.

"Gordon Rainsford" wrote in message
news:1h8lh5l.1h2kddapplefkN%grbridgeREMOVETHIS@bti nternet.com...
Niek Otten wrote:

Please don't post to multiple groups in separate messages.

See answer in other newsgroup

This is an unfortunate approach for those of us who don't know what
other groups it has been posted to, but would have been interested in
the answer to the question.


--
Gordon Rainsford

London UK