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.