get the value of a formula in cell B1 into cell A1 without changing my current cell selection

N

News

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
 
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top