C
Chas
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
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