Kathryn has attended:
Excel Intermediate course
Macro
How do you record a formula in a macro without copying the values? I want to use a macro to sort a list and divide a cell by 10%. However, when I record the macro, it saves my values. I want to be able to insert any values.
RE: Macro
Hi Kathryn, thank you for your question.
It is possible to create a Macro that allows you to change the values however this would require some programming (rather than recording) the macro.
For example using the Visual Basic for Applications (VBA) programming language it would be possible to add a message box to the macro so that it asks for the values you wish to use when it runs.
Unfortunately that is outside the scope of this forum - however you may be interested in our Excel VBA training course. You can find details here.
Do let me know if you have any further questions.
Kind regards,
Andrew
