Copy number that changes daily with macro

[RoyC]

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

[Tom Ogilvy]

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" <[email protected]> wrote in message
news:[email protected]...
> 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