If you are entering this in the Excel formula bar, try:

=A2&" to"&B2

The syntax looks like you are using VBA code outside of a macro.



"RyanH" wrote:

I have a chart that displays data between two dates. I want the title to
read like this:

Range("A2").Value & " to " & Range("B2").Value

I highlighted the title box and entered this in the formula bar and Excel
will not accept it, why?

=Summary!$A$2&" to "&Summary!$B$2
--
Cheers,
Ryan