Bookmark page
Printable version
Course updatesForum home » Delegate support and help forum » Microsoft Excel VBA Training and help » VBA/Excel
|
|
|
Bookmark this page|
The UK's most regular Training information: |
|
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. |
VBA/Excel
Resolved · Low Priority · Version 2003
Reply
VBA/Excel
If in the VB code you have told it to add cell A1 with cell A2 and return the answer in cell A3, can you get the code to return the answer as well as the formula used.eg
So if A1 = 2 and A2 = 3, cell A3 returns 5, as wells as showing when you click in cell A3 that the calculation is =A1+A2
For upcoming training course dates see: Pricing & availability
RE: VBA/Excel
Hi Justin,Thank you for your question and sorry about the delay in responding.
After speaking to my colleague I would suggest you use the FormulaR1C1 property of the activecell object and then create a loop to repeat the procedure for the other totals.
During the course I believe you were starting to think along these lines.
I hope this helps.
Regards
Simon
|
 |
|
» Forum post: Importing data |
Can I import a non-tabbed, non-comma seperated wordpad / notepad document into Excel?
