With functions such as pivotTable.TableRange I am able to see the column and row indices such as 6, 2 but I can also see something like B10:G12 i.e. actual Excel column headings (which is exactly what I want) but I can’t find any way of extracting these Excel headings!
Please provide us your sample Excel file and sample code as well as a screenshot that should let us know what you want to extract with red circles around the area of your interest.
It is good to know that you were able to sort out your issue. Let us know if you encounter any other issue, we will be glad to look into it and help you further.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
Enables storage, such as cookies, related to analytics.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.