| 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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use information from an input box in cell reference formula
Maybe
response = InputBox("enter row") ActiveCell.FormulaR1C1 = "=PURCHASING!R[" & response & "]C[18]" Mike "Chas" wrote: 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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use information from an input box in cell reference formula
Still doesn't work, I've been getting a run time error every time I try.
Thanks "Mike H" wrote: Maybe response = InputBox("enter row") ActiveCell.FormulaR1C1 = "=PURCHASING!R[" & response & "]C[18]" Mike "Chas" wrote: 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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use information from an input box in cell reference formula
is your relative cell off the worksheet?
"Chas" wrote: Still doesn't work, I've been getting a run time error every time I try. Thanks "Mike H" wrote: Maybe response = InputBox("enter row") ActiveCell.FormulaR1C1 = "=PURCHASING!R[" & response & "]C[18]" Mike "Chas" wrote: 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 |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use information from an input box in cell reference formula
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 |
| Reply |
| 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) | |||
Hybrid Mode
