View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Abid[_3_] Abid[_3_] is offline
external usenet poster
 
Posts: 2
Default Copy past function on cell containing selective formula

Hi,

I am extensive user of Hyperion Smart view. Usuualy I sent out report after
converting them into value as most of the recipeint do not have access to
Hyperion server. This make reports un-editable as all formula e.g. sum,
average etc are also convereted to values. Any idea as to how to write a code
which converts only cells with HSGETformula to value and leave others alone?

Thanks