Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I store through a cell that contains a cell address in it?
I have an Excel (2003) cell that contains a derived address of another cell
in my spreadsheet. For example I may be at Cell j20, and in that cell I have the absolute addtess $B$16. I want to set $B$16 to a specific value. This address can change, so I can't just "hard code" the $B$16 somewhere else. I have to do an indirect store through J20 TO $B$16, and place my datum at $B$16. However, $B$16 can change with respect to other conditions in the sheet. I can do the equivalent of a "Load Indirect" easily. How do I do a "Store Indirect". Thankx! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I store through a cell that contains a cell address in it?
Consider using a macro:
Sub kitty() adrs = Range("J20").Value Range(adrs).Value = Application.InputBox(prompt:="Enter datum:", Type:=1) End Sub make sure you have already loaded the correct address in J20 and then run the macro. -- Gary''s Student - gsnu200802 "Big Gray Cat" wrote: I have an Excel (2003) cell that contains a derived address of another cell in my spreadsheet. For example I may be at Cell j20, and in that cell I have the absolute addtess $B$16. I want to set $B$16 to a specific value. This address can change, so I can't just "hard code" the $B$16 somewhere else. I have to do an indirect store through J20 TO $B$16, and place my datum at $B$16. However, $B$16 can change with respect to other conditions in the sheet. I can do the equivalent of a "Load Indirect" easily. How do I do a "Store Indirect". Thankx! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I store through a cell that contains a cell address in it?
A formula can only affect the cell that it is in. It can not write to another
cell. Either look at using Gary's macro or you will need to re-engineer your solution... -- HTH... Jim Thomlinson "Big Gray Cat" wrote: I have an Excel (2003) cell that contains a derived address of another cell in my spreadsheet. For example I may be at Cell j20, and in that cell I have the absolute addtess $B$16. I want to set $B$16 to a specific value. This address can change, so I can't just "hard code" the $B$16 somewhere else. I have to do an indirect store through J20 TO $B$16, and place my datum at $B$16. However, $B$16 can change with respect to other conditions in the sheet. I can do the equivalent of a "Load Indirect" easily. How do I do a "Store Indirect". Thankx! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Store cell value and set to zero | Excel Discussion (Misc queries) | |||
store address in a cell and use it in formula | Excel Discussion (Misc queries) | |||
Data Validation: Store cell address instead of value in the cell? | Excel Discussion (Misc queries) | |||
Store max value of changing cell | Excel Worksheet Functions | |||
store some of the information from one cell into another | Excel Discussion (Misc queries) |