Hello all - I've tried finding an answer to this on the web and here, but have had no luck, though I know it's out there somewhere. I've done this before, but can't for the life of me remember the appropriate syntax.
I'm simply trying to use two variables (in this example, cellc and celld) in a formula:
ActiveCell.Offset(1, 0).Formula = "=""What is the "" & cellc & "" of "" & B2 & "", "" & A2 & "","" & celld"
Instead of ending up with "What is the (x) of (y)..." I'm seeing my variables as a literal string:
="What is the " & cellc & " of " & B2 & ", " & A2 & "," & celld
I've tried using single sets of quotes instead of the doubles, but that didn't do it either.
Thanks for any assistance!
Bookmarks