Thread: use information from an input box in cell reference formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
chas chas is offline
external usenet poster
  
Posts: 40
Default use information from an input box in cell reference formula
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
Reply With QuoteReply With Quote