Works OK for me -- what's happening when you use it? (I assume there's a
worksheet named PURCHASING).


"Chas" wrote in message
...
I have an input box that promps for a row number which I then want to use
in
a cell reference on a different tab. For some reason my concatenation
isn't
working.

ActiveCell.FormulaR1C1 = "=PURCHASING!R[" & row & "]C[18]"

where row = the input box information

Any help is greatly appreciated.

thanks