order by compound annual growth rate in pivot and vb macro

[#1]

Hello fellows

I request your kind help for the following

What i have

A pivot table with name, years and quarteres pivoted and an amount and the CAGR as expressions, the posibility to sort by any combination of expression, year and quarter

What's the problem

The formula for the CAGR in the pivot its fine, but how to transcribing in the macro, the guess here is the last part of the POW() function, i can't get the columnno()

I can't figure out why columnno() does not work in this part, is there a function like autonumber() for using in a macro?

If you analize a little, what is needed here is just an incrementar number that shows the active column (obviously it depends of the selections made)

I hope the masters please help me

Thanks

[#2]

I forget to attach the qvw