Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Pivot Table Range


Can I use a variation of First:Last!D5..E15 as a pivot table range
to use the range D5..E15 of every sheet between D5 and E15 ?

Thank You

MK
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 17
Default Pivot Table Range


FOUND A WORK AROUND.

Thanks

"lab-guy" wrote:


Can I use a variation of First:Last!D5..E15 as a pivot table range
to use the range D5..E15 of every sheet between D5 and E15 ?

Thank You

MK

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,480
Default Pivot Table Range

Hi

And for the benefit of us all, the workaround was????

--
Regards
Roger Govier

"lab-guy" wrote in message
...

FOUND A WORK AROUND.

Thanks

"lab-guy" wrote:


Can I use a variation of First:Last!D5..E15 as a pivot table range
to use the range D5..E15 of every sheet between D5 and E15 ?

Thank You

MK

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Pivot table and value range Nicawette Excel Discussion (Misc queries) 2 December 28th 09 09:09 AM
Code that will rerun or refresh a pivot table (after new data ispasted into the original Pivot Table's Source Range) Mike C[_5_] Excel Programming 3 February 15th 08 06:22 AM
Pivot Table Range Scott R Excel Worksheet Functions 1 September 27th 07 06:56 AM
get range in pivot table Britton Excel Programming 0 October 6th 06 09:21 PM
Setting Range in Pivot Table Dhiraj Charts and Charting in Excel 1 August 15th 05 01:27 AM


All times are GMT +1. The time now is 11:46 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"