98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Macro
Macro
Resolved · Low Priority · Version 2010
Fri 9 Sep 2011, 12:56Delegate Kathryn said...
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.
Tue 13 Sep 2011, 11:58Trainer Andrew said...
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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
