| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Silly Problem with Variable (2nd attempt)
I'm new to VBA. I'm passing a value to "Acell": Acell = ActiveCell However, the following code does not work: ActiveSheet.PivotTables("PivotTable10").PivotField s("utcid") .PivotItems(Acell).Visible = False But when I manually put in "37" (in quotes), it works. Please help. BTW, is there a way to follow your code step by step? similar to the formula auditing tool in Excel? -- pikapika13 ------------------------------------------------------------------------ pikapika13's Profile: http://www.excelforum.com/member.php...o&userid=10892 View this thread: http://www.excelforum.com/showthread...hreadid=528593 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| variable height variable width stacked bar charts | Charts and Charting in Excel | |||
| problem with Array Formula | Excel Worksheet Functions | |||
| Copy an Drag cell Formula Problem | Excel Discussion (Misc queries) | |||
| Paper Tray selection Problem, | Excel Discussion (Misc queries) | |||
| File is locked for Editing by user problem | Excel Discussion (Misc queries) | |||
Threaded Mode
