Help modifying Un-Pivot Macro

Hello,

I got the un-pivot code here (the rewitten part of "snb’s approach") it is blazing fast.

The problem is that the range to unpivot is imputed with msgboxes and I am always un-pivoting the same table with different data in it so I would like to hard code the ranges asked for.

I have tryed but not getting it.

There is only the pivot table on the active sheet

The range of the headers to the LEFT not to be un-pivoted is col A to G

The range of header to the RIGHT to be un-pivoted is col H to last column

Below is that part of the code that ask for the prompts

Thank you

Please Login or Register  to view this content.

With a little more patients I got

Please Login or Register  to view this content.