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