Worksheets("Sheet2").Range("B9").value _
= Worksheets("Sheet1").Range("A1").Value

will put the value from A1 on Sheet1 in B9 of sheet2.

--
Regards,
Tom Ogilvy


"RoyC" wrote in message
...
I am attempting to write a macro that needs to copy a number (it changes
daily). However, when I review the macro it only uses the initial number
that
I copied when I initially created the macro. Any suggestions