Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Tables
Quote: Then R1C1:R6C6 I would have thought to be some kind of range, but then why wouldn't it be A1:B4 or something smaller like that? Apparently the syntax for the pivot table is different than for the rest of excel. Instead of "columnletter""rownumber" it's R"rownumber"C"columnnumber". So B3:D5 would be R3C2:R5C4. -- kslays ------------------------------------------------------------------------ kslays's Profile: http://www.excelforum.com/member.php...o&userid=37029 View this thread: http://www.excelforum.com/showthread...hreadid=350107 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Building pivot tables in Excel 2007 based on existing pivot tables? | Excel Discussion (Misc queries) | |||
Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
Average Calculations from Pivot Tables - Get Pivot Data? Calc Fiel | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) | |||
Pivot tables-controlling user interaction with pivot tables | Excel Programming |