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.

Buy youself a BASIC or programming manual (seriously, you will
discover a lots of "tricks"). For example, if you need string
quotation character inside the string - just double it:
"""" - will result a " in string.

Could you provide the example?

When I doubled the quotations it gave a compile error.

Thank you

"NOPIK" wrote:

Buy youself a BASIC or programming manual (seriously, you will
discover a lots of "tricks"). For example, if you need string
quotation character inside the string - just double it:
"""" - will result a " in string.

Thank you NOPIK - I understand you to mean that not just an extra set of
quotes, but two extra sets around the text. Anyway it works - thank you
again.

"NOPIK" wrote:

Buy youself a BASIC or programming manual (seriously, you will
discover a lots of "tricks"). For example, if you need string
quotation character inside the string - just double it:
"""" - will result a " in string.