Jeff,

If A2 is a date:
Range("C5").Value = "From January 2005 to " & Format(Range("A2").Value,
"mmmm yyyy")

If A2 is a string:
Range("C5").Value = "From January 2005 to " & Range("A2").Value

HTH,
Bernie
MS Excel MVP

"Jeff" wrote in message
...
Hello,

I need help designing a VBA macro that would the following:

I have in row C5 "From January 2005 to xxxx"
I'd like to replace or update xxxx by the current month, which I have in
cell A2.
Thanks,