Variable in R1C1

[Analyze_This]

I'm trying to set up a FOR NEXT loop with the variable X. (I know that you shouldn't set x as a variable, but it referrs to so many differnt things in the code that I couldn't think of a more descriptive name)
The problem that I have is that I can't seem to set the variable in an R1C1 formula because it of all the quotation marks. Here is how the formula currently looks

ActiveCell.FormulaR1C1 = "=""Late ""&TEXT(RC[2],""[H]:MM:SS"")"

The red 2 above is what I would like to place as x, but I can't seem to figure out the proper arrangement of quotation marks to make it work. Any ideas?

 

[texasalynn]

try this
ActiveCell.FormulaR1C1 = "=""Late ""&TEXT(RC[" & x & "],""[H]:MM:SS"")"

 

[Analyze_This]

It worked, but that was the first thing I tried before I posted. It seems that the key factor in making this work was adding in spaces before and after the ampersand (&). Is that necessary every time that you concatinate something? If it is why wouldn't VBA just add in the spaces like it does with everything else?

 

[Norie]

Analyze This

I think the main thing is actually the doubling up the quotes surrounding 'Late'.

Though VBA can be a little fussy with spaces when concatenating.

And there seems to be no rhyme nor reason behind it's fussiness.