How do I record a macro and NOT have my cell formulas show up in R1C1 style
when I open the macro with Visual Basic

oe How do I change all the cell formulas in a module once recorded ??

#1. I think that's the way the macro gets recorded. (I can't change it.)

#2. depends on what you're doing...edit|replace or manually???



Richard wrote:

How do I record a macro and NOT have my cell formulas show up in R1C1 style
when I open the macro with Visual Basic

oe How do I change all the cell formulas in a module once recorded ??

--

Dave Peterson