Recording Macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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???
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to record macro with relative addressing in Excel 2000 3
macro recorder and formulas 2
Pasting cell contents into a macro 1
Recording a Macro?? 3
Record Macro greyed out 4
Macro to extend formulas 4
Can I insert formulas into my macros? 3
Need macro to move to first blank cell in column 6

Back
Top