Expand/ Collapse Cell using named range

[a_dani20]

Hi guys I recently read an article on http://chandoo.org/wp/2011/04/27/update-report-filter-macro/ In this article one interesting thing i noticed was expand/collapse option using named formula.. but i was unable to understand it.. pls help??

 

[dan_l]

I don't see what you're referring to. Can you post what the name formula is?

 

[a_dani20]

this is the name formula "imgHideShowDesc"

 

[dan_l]

This may get you going down he right path :


http://chandoo.org/wp/2008/11/05/select-show-one-chart-from-many/

 

[NARAYANK991]

Hi ,


Check out the document at the following link :


https://docs.google.com/document/d/1UIO-dpOpj4OmELkdtxnfSVVGO886HE8l8YBR8n_p044/edit


Narayan

 

[a_dani20]

very well explained.. thanks