Hide Rows or Coloumns using formulas

[Milind Keer]

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

 

[Pete_UK]

Well, the answer is NO - a formula cannot hide a row or a column.

Pete

 

[Milind Keer]

oooppppsss!!!

in dat case i guess i need to write macro...

anywayz thanks pete!!

cheers!!
milind

 

[Dave Peterson]

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

 

[Bob I]

Use one worksheet per month?

 

[Milind Keer]

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

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