PivotTable Active Range

[Jerseynjphillypa]

This is the code I believe I should use to select the Active Region for a PivotTable instead of calling for R1C1:R5900C26.

Please Login or Register  to view this content.

The column I need is from A to Z, and select all the rows going down.

Please Login or Register  to view this content.

[BigBas]

Just an idea if all of your data is in proper order, you can set a range variable to include the current region. Then you can refer to the variable as necessary

For example:

Please Login or Register  to view this content.

Let me know if that helps at all.

[Jerseynjphillypa]

I'm not sure how to update the line with the following code above.

I tried to replace SourceData:="Table!R1C1:R5900C26" with your code but it didn't work

I took your idea and get the range by using the Create Names from Selection by using the top row.

Please Login or Register  to view this content.

[BigBas]

I don't have Excel 2007 at the moment, so it's a bit harder for me to test. Your code would look something like the following (using original code):

Please Login or Register  to view this content.

Does that work, or do you throw any errors?

[wakeupcall]

Hi,

how abut this one

Please Login or Register  to view this content.

[Jerseynjphillypa]

thanks for your help but I just need to read through your code to find the missing ) since when I try to run your code I get a Compile error: Expected: List separator or )

Hi,

how abut this one

Please Login or Register  to view this content.

---------- Post added at 10:46 AM ---------- Previous post was at 10:45 AM ----------

Thanks for both your help.