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
|