Are you saying you want the "formula" stored in the variable, but without
its leading equal sign? If so, try this...

YourVariable = Mid(ActiveCell.Formula, 2)

Rick


"dstiefe" wrote in message
...
i am using the "activecell.formula" function

when i assign it to a variable i see the "=" sign

how do i erase the = sign?

Thank you