Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Run-time Error 1004
Hi There, I have a problem with some code which causes a pivot table to change. The strange thing is that the code worked fine until I updated the pivot table with some new data from Microsoft Access, all the names are the same but all of a sudden I get "Run-time error 1004: Unable to set the...- Zwicky
- Thread
- Replies: 6
- Forum: VBA Visual Basic for Applications (Microsoft)
-
If Optionbutton value is true then
Hi There, Hopefully an easy one for someone... What code do I use in Excel vba to do an if/then statement depending on whether an option button is checked or not? My optionbutton is called "ob1" and it's in sheet "Vary". I tried If Sheets("Vary").Shapes("ob1").Value = True Then But it gives...- Zwicky
- Thread
- Replies: 8
- Forum: Microsoft: Office
-
Change Pivot Table Name without Select
Hi Everyone, I am trying to change a pivot table name in excel vba code within a worksheet_change function (Private Sub WorkSheet_Change(ByVal Target As Excel.Range)which does not allow you to use the select method for another worksheet. I have tried...- Zwicky
- Thread
- Replies: 1
- Forum: Microsoft: Office
-
Excel PivotTable Lookup Overwrites Data
I have a pivot table in Excel that references external data in Access. The pivot table is changed via a worksheet which acts as a user form. The user selects from a list and vba code causes the pivot table values to change. One of the selections consists of three consecutive lists which...- Zwicky
- Thread
- Replies: 2
- Forum: Microsoft: Office
