Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing a character in the
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing a character in the
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
erasing a character in the
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Erasing a spreadsheet | Excel Discussion (Misc queries) | |||
erasing outside print area | Excel Discussion (Misc queries) | |||
Erasing a Formula? | Excel Discussion (Misc queries) | |||
Erasing a excel file | Excel Discussion (Misc queries) | |||
erasing checkboxes | Excel Programming |