Number format

[#1]

Hi

Im exporting the Pivot table view in Excel using Macro.....

thr are more than one view .....

the problem is some of the views have % number format to one of its column,

but while exporting to excel using Macro I hv to use tht format and need to mention it in Macro for tht perticular column.

Now as required, I must have single macro to generate  view  and im going to call it on each button click as each button click is dedicated to one particular view.

so how can I find out tht what column of wat view has % number format.

Thnx

[#2]

could You post this macro here?

[#3]

well

I cant ..

but I can put a scenario similar to it....

see...

I have one Macro as

sub xyz

.....

end sub

n I gonna hv 4 views v1,v2, v3,n v4 also 4 buttons b1,b2,b3,b4

on b1 click v1 will get export to excel.. similarly..

b2 click v2 will get export to excel likewise...

but Im gonn call same macro xyz on each button click.

now the problem is v1 and v3 each.. have 1 column with % number format.....but v2 , v3 doesnt hv ......

In view, I hv already set the number format to %.

but if I want to display in Excel ..I need to mention it again in Macro...

but since Im unaware about  wat column has % format how can I assign the % format to tht column n ofcourse in case of those two views i.e. v1 n v3....

cause If I hard-code it thn it will affect those v2, v4 views cause they dont hv such columns...