Wow! Things are easy when you know stuff. Thanks Jim!
Mike

"Jim Thomlinson" wrote in message
...
You can give this a try... It does not change the cell selection nor does
it
require sheet 1 to even be the active sheet...

Sheets("Sheet1").Range("A1").value = Sheets("Sheet1").Range("B1").value
--
HTH...

Jim Thomlinson


"News" wrote:

Can someone tell me how in an Excel macro I can get the value of a
formula
in cell B1 into cell A1 without changing my current cell selection?

THANKS!
Mike