Hi,

I am unable to concatenate the word "Total " with a cell address.

Here's my script:
ActiveCell.Offset(0, 1).Formula = "+Total " & " & " & (ObjectHeadAddress)

The result is: +Total & E73

I would like the formula to come out looking like : +"Total "&E73
so that the formulae in the cell is meaningful.

Please advice how to get the extra " " marks around the work Total. When I
try to put in the extra quotation marks, I get the debug error message.

Thank you in advance.