erasing a character in the

[dstiefe]

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

 

[cht13er]

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

 

[Rick Rothstein \(MVP - VB\)]

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

 

[Dave Peterson]

Dim myStr as string
mystr = mid(activecell.formula,2)

The worksheet function =mid() needs more parts (the length). VBA's Mid doesn't
need that.