Using a Defined Variable in a Formula through VBA

[iancook1982]

hi,
I'm probably being really stupid but I can't figure this out.

So, I have a string variable that I have being input through an Input box, this variable is
Dim VP as string
This is carried through to a private function where I want to add this into a formula. The formula is a simple one, just a concatenation.

activecell.formulaR1C1 = "<what would i write in here to put my VP value> &""_""&RC[1]"

Thanks,
Ian.

 

[VoG]

Try

ActiveCell.FormulaR1C1 = "=" & Chr(34) & VP & Chr(34) & " & ""_"" & RC[1]"

 

[iancook1982]

thanks that works great.

Kind Regards.