| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Type Mismatch when creating a pivottable macro
I've been searching through this group for similar problems (and found one) but I was still unable to resolve the issue below. When I try to set bigcache, it throws a type mismatch at me and I'll be damned if I can work it out. Any help is much appreciated. My code is: <snip Dim bigcache As Variant Have you tried making bigcache a PivotCache instead of a Variant? Iain King |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Error type mismatch in writing macro | Excel Worksheet Functions | |||
| Macro error type mismatch | Excel Discussion (Misc queries) | |||
| Visual Basic macro run time error(13) type mismatch | Excel Discussion (Misc queries) | |||
| Creating a database and PivotTable with a Macro | Excel Programming | |||
| Type mismatch | Excel Programming | |||
Threaded Mode
