erasing a character in the
On Mar 25, 3:12*pm, dstiefe wrote:
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
When you pass it to a variable (if the variable is a string) just say
something like strFormula = Mid(Cstr(Activecell.Formula),
2,len(activecell.formula)-1) ... does that work?
Chris
|