Not exactly sure

O

oliroe

Difficult for me to describe. I would like to have a formula such a
+100*50 and in the neighbouring cell have the text "100 x 50." Can'
find a way of pulling the numbers out of a formula

Any help would be greatly appreciate
 
M

mk

Difficult for me to describe. I would like to have a formula such as
+100*50 and in the neighbouring cell have the text "100 x 50." Can't
find a way of pulling the numbers out of a formula
Click to expand...
You have to use a custom formula:

Public Function formulais(address)

formulais = address.FormulaLocal

End Function
 
Top