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.

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

--

Dave Peterson