OFFSET FROM SELECTION and insert formula

HI

i would like an excel VBA to do the following

i would like to select a range in a column lets say from A1 to A10 and i want that automatically when i run the macro, in the next column right next to where i selected it should input a function for ex =len(a1)

thanks

thanks that worked, I just want to add one more thing that if anything in my selection contains the "-" symbol it should remove it

thanks

Please Login or Register  to view this content.

HI

one more question how can i have two formulas for ex.

.Formula = "=len(SUBSTITUTE(...

i cant seem to figure it out

thanks

You did not mention which post you were referring to but is this what you mean?

Please Login or Register  to view this content.