Sam

Need a few more double quotes.

Range("A5").Formula = "=""Summary of "" & B1 & "" manual comparison."""


Gord Dibben MS Excel MVP


On Fri, 23 Feb 2007 16:35:00 -0800, Sam wrote:

I want to enter a combination text/cell value in a cell, but vba won't let
me. It expects the end of the statement. Example: Range("A5").Formula = _
"=Summary of "&Q1&" manual comparison."

... where Range("Q1") could be "Current" or "MTD".

Any help would be appreciated.

Sam