View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alan B Alan B is offline
external usenet poster
 
Posts: 8
Default Pivot Table - VBA

I have a workbook into which I import dat from my Oracle database. I then
use VBA macros to create a pivot table and analyse the data. One of the
macros takes a drop down and deselects 7 of the 10 choices. I'd like to do
this differently i.e. I would like to deselect all the select the ones that I
want rather than have all selected and de-select the ones I don't want. Any
tips will be gratefully received.

Thanks

Alan