| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reference a cell on another sheet and have the information auto up | Excel Worksheet Functions | |||
| How to have information auto input if cell = yes | Excel Worksheet Functions | |||
| information function - does cell contain reference | Excel Worksheet Functions | |||
| How do I reference Cell information in my Headers? | Excel Discussion (Misc queries) | |||
| Input cell information | Excel Discussion (Misc queries) | |||
Threaded Mode
