| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
use the range value from a cell to update the cell with data
I have 3 values. Value one refers to the row number, value 2 referes to the
column number and value 3 is the data I want to put in the cell. I would like a button to use value 1 and 2 to locate the cell and put value 3 into it. I can calculate the exact cell using Address function as follows but don't know the code to update the value in the cell. Thanks. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use the range value from a cell to update the cell with data
Sub place_it()
value01 = 20 value02 = 13 value03 = 123.456 Cells(value01, value02).Value = value03 End Sub -- Gary''s Student - gsnu200759 "wvan" wrote: I have 3 values. Value one refers to the row number, value 2 referes to the column number and value 3 is the data I want to put in the cell. I would like a button to use value 1 and 2 to locate the cell and put value 3 into it. I can calculate the exact cell using Address function as follows but don't know the code to update the value in the cell. Thanks. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use the range value from a cell to update the cell with data
Thank you. How do I get the value for instance from a4 to replace the
current value 20 you assigned? "Gary''s Student" wrote: Sub place_it() value01 = 20 value02 = 13 value03 = 123.456 Cells(value01, value02).Value = value03 End Sub -- Gary''s Student - gsnu200759 "wvan" wrote: I have 3 values. Value one refers to the row number, value 2 referes to the column number and value 3 is the data I want to put in the cell. I would like a button to use value 1 and 2 to locate the cell and put value 3 into it. I can calculate the exact cell using Address function as follows but don't know the code to update the value in the cell. Thanks. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use the range value from a cell to update the cell with data
Thank you. How do I get the value, for instance from cell a4 to replace the
current value 20 you assigned? "Gary''s Student" wrote: Sub place_it() value01 = 20 value02 = 13 value03 = 123.456 Cells(value01, value02).Value = value03 End Sub -- Gary''s Student - gsnu200759 "wvan" wrote: I have 3 values. Value one refers to the row number, value 2 referes to the column number and value 3 is the data I want to put in the cell. I would like a button to use value 1 and 2 to locate the cell and put value 3 into it. I can calculate the exact cell using Address function as follows but don't know the code to update the value in the cell. Thanks. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use the range value from a cell to update the cell with data
Sub place_it()
value01 = Range("A1").Value value02 = Range("A2").Value value03 = Range("A3").Value Cells(value01, value02).Value = value03 End Sub -- Gary''s Student - gsnu200759 |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use the range value from a cell to update the cell with data
Hi again,
A4 = $H$14 (used =ADDRESS(MATCH(B1,A1:A32,1),MATCH(B2,A5:EF5,1))) to calculate A4 B3 = P1 value01 = Range("A4").Value value03 = Range("B3").Value Cells(value01).Value = value03 I get the error "Type Mismatch", can you help me again with this? Thanks so much. "Gary''s Student" wrote: Sub place_it() value01 = Range("A1").Value value02 = Range("A2").Value value03 = Range("A3").Value Cells(value01, value02).Value = value03 End Sub -- Gary''s Student - gsnu200759 |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use the range value from a cell to update the cell with data
Cells() needs two arguments, Range() only needs one.
-- Gary''s Student - gsnu200759 "wvan" wrote: Hi again, A4 = $H$14 (used =ADDRESS(MATCH(B1,A1:A32,1),MATCH(B2,A5:EF5,1))) to calculate A4 B3 = P1 value01 = Range("A4").Value value03 = Range("B3").Value Cells(value01).Value = value03 I get the error "Type Mismatch", can you help me again with this? Thanks so much. "Gary''s Student" wrote: Sub place_it() value01 = Range("A1").Value value02 = Range("A2").Value value03 = Range("A3").Value Cells(value01, value02).Value = value03 End Sub -- Gary''s Student - gsnu200759 |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
use the range value from a cell to update the cell with data
Just perfect, thanks so much.
"Gary''s Student" wrote: Cells() needs two arguments, Range() only needs one. -- Gary''s Student - gsnu200759 "wvan" wrote: Hi again, A4 = $H$14 (used =ADDRESS(MATCH(B1,A1:A32,1),MATCH(B2,A5:EF5,1))) to calculate A4 B3 = P1 value01 = Range("A4").Value value03 = Range("B3").Value Cells(value01).Value = value03 I get the error "Type Mismatch", can you help me again with this? Thanks so much. "Gary''s Student" wrote: Sub place_it() value01 = Range("A1").Value value02 = Range("A2").Value value03 = Range("A3").Value Cells(value01, value02).Value = value03 End Sub -- Gary''s Student - gsnu200759 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Validation lists update orginal cell with list update | Excel Worksheet Functions | |||
| Summed Cell won't update as I add data into the cell range... | Excel Worksheet Functions | |||
| Update cell based on date range | Excel Discussion (Misc queries) | |||
| Enter data into a cell and dynamically update another cell | Excel Programming | |||
| Enter data into a cell and dynamically update another cell | Excel Programming | |||
Linear Mode
