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