#1
|
|||
|
|||
Macro recorder changing reference style for columns in pivot source
So if I record a macro selecting rows A:H as the source for a pivot table, in the VBA Excel will refer to these columns as "C1:C8", presumably meaning column one to column eight. If I selected columns C:J, it would translate into the VBA as "C3:C10". This isn't A1 or R1C1 referencing style, so what is it, and why is Excel being so silly? The ramification of referring to cells like this is that it overlaps with A1 style, so Excel would presumably read the VBA as referring to cells C1:C8, rather than columns 1:8/A:H. It's easy enough to change this in the VBA, but I'm just confused as to why it's doing this and if there is a solution. Andy |
Tags |
columns, pivot, source |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing a Linked Style to Paragraph with a Macro | Rose43526 | Word VBA | 3 | 10-27-2015 02:02 PM |
How do I find Source of Pivot Table | bobmayo | Excel | 2 | 05-16-2013 12:42 PM |
Macro recorder and ShowFieldCodes | Jennifer Murphy | Word VBA | 1 | 11-04-2012 01:55 AM |
Picture properties bug in Word 2010 Macro Recorder | ralphpickering | Word VBA | 5 | 10-24-2012 10:15 AM |
pivot table source data | hannu | Excel | 0 | 07-03-2010 04:54 AM |