Say we want to put a message in Sheet2
Sheet1, cell A1 contains Z100 (the destination address)
Sheet2, cell A2 contains the message:

"Klaatu barada nikto"


Here is a sample macro:

Sub gort()
Set a1 = Range("A1")
Set a2 = Range("A2")
destin = a1.Value
a2.Copy Sheets("Sheet2").Range(destin)
End Sub


--
Gary''s Student - gsnu200798


"jpbat1591" wrote:

Hi,

I am wondering if anyone could shed some light on how i can program a value
say in A1 that is constantly changing, and use the value as the destination
to paste information on another sheet.