I am trying to past the formula from a cell into another
cell as text. That is if cell A1 has a formula which is
=Sum(A2:A10). I want to be able to past the text version
of this to say B1. So B1 will say 'Sum(A2:A10). How do
you do this?

I have been trying:

Range("B1") = Range("A1").formula

But this is not giving me what I want.

THanks