not really... i wrote a macro...

"Dave Peterson" wrote:

Have you thought of using data|filter|autofilter (xl2003 menus)?

Milind Keer wrote:

Hi All

Is there any way to hide rows or coloumns using formulas

E.g. I have a data for all 12 months and i want XL to display data for only
selected month

Like if i select Feb-08 it should display only Feb-08 data and should hide
rest of the coloumns

I dont want to manually hide my data or use outline view.

Please advise

Thanks and Regards
Milind Keer

--

Dave Peterson