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 derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Type Mismatch
Thank you so much. That worked. It has been driving me slowly mad. Thanks again. -
Type Mismatch
Thank you for your response. When I use groupRange.Cells(1).Group(TRUE,TRUE,7,MyArray) I get the vbScript compilation error "Cannot use parenthesis when calling a sub" and when I use groupRange.Cells(1).Group(Start=TRUE, End=TRUE, By=7, Periods=MyArray) I get the vbScript... -
Type Mismatch
I am attempting to manipulate an existing excel pivot table using vbscript. I want to group the pivot table by 7 day weeks. I can sucessfully group by months but when I try to group by days I get a type mismatch error. The script I am using is below: myArray =...
