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 VBA Training and help » Pivot tables
Pivot tables
Resolved · Low Priority · Version 2007
Tue 10 Aug 2010, 16:00Delegate Oz said...
Oz has attended:
Excel VBA Intro Intermediate course
Pivot tables
Is there a quick way to deselect and select items in a pivot table using VBA?
Thu 12 Aug 2010, 02:00Trainer Anthony said...
RE: Pivot tables
Hi Oz, thanks for your query. You can select elements in a pivot table in exactly the same way as elements in a normal table. For example:
Range("A4").Select
Hope this helps,
Anthony
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. |
Excel tip:Adding up rows or columns without seeing formulasHighlight a column or row and click the Autosum button. This gives you your answer without showing the formula. |
