I am writing a macro to save the name in cell A1 and I have a date Value in
cell B5

I am wanting excel to suggest for example greg 15 june 2005

here is the code so far but it wont save because it is coming up 16/6/2005

Suggestion = Range("A1").Value & Range("B5")

Thank in advance

Greg