I have a very complicated cell formula stored in a particular cell of a
worksheet. I wish to copy the formula EXACTLY AS IT IS STORED in Cell A1 of
worksheet A to Cell BB1 of worksheet 2, but to do so within a macro. When I
attempt to copy the formula within the macro, it makes a number of changes to
the contents upon copying the cell. All I want to do is actually copy the
exact syntax of the formula which has no relevance to the cell in which it is
actually stored -- I just store it there because I don't want to loose the
syntax. It's quite complicated so attempting to create it in VBA is too
complicated.

Any suggestions?