How to change coding in Macro for Pivot

I'm trying to run a pivot in Macro where the Pivot needs to choose the whole sheet and not a specific range as the data pasted in the sheet may fall in different range or rows however the columns are stable.,

Below given is the coding for that Macro Recording for Pivot.

Please Login or Register  to view this content.

Thanks in advance for the help.,

Hi sudharshan and welcome to the forum,

It sounds like you need to find the last row of data in your pivot data. I use this type of code...

Please Login or Register  to view this content.

Then LastRow will be the last row in the table with data in Column A.

I hope this helps....

You could also use a Dynamic Named Range for your data and use the name of the Range instead of the LastRow idea above.

http://www.bettersolutions.com/excel...G820716330.htm

Hi,

Please remove your code from your first post or put it in CODE brackets. Edit the post, select the CODE and click the "#" icon above the message area.

Then - I have an example of what I mean. See the attached for what I think you want.