Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-15-2016, 08:45 AM
andylaw31 andylaw31 is offline Macro recorder changing reference style for columns in pivot source Windows 7 32bit Macro recorder changing reference style for columns in pivot source Office 2010 32bit
Novice
Macro recorder changing reference style for columns in pivot source
 
Join Date: Aug 2015
Posts: 2
andylaw31 is on a distinguished road
Question 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
Reply With Quote
Reply

Tags
columns, pivot, source

Thread Tools
Display Modes


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
Macro recorder changing reference style for columns in pivot source How do I find Source of Pivot Table bobmayo Excel 2 05-16-2013 12:42 PM
Macro recorder changing reference style for columns in pivot source Macro recorder and ShowFieldCodes Jennifer Murphy Word VBA 1 11-04-2012 01:55 AM
Macro recorder changing reference style for columns in pivot source 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

Other Forums: Access Forums

All times are GMT -7. The time now is 02:32 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft