How to "Remove" #REF!???

H

hce

Hi Frank

Thanks for your help! It worked perfectly!

Hi Gord

Thanks for your comments... I learnt alot from your comments... I hav
to apologise for not posting a clearer post... The formula I had wa
GetPivotData(....) hence if the specified field in the formula is no
there, then it will become #REF!. Hope this will help to clear th
confusion...

Cheer
 
Top