Formula to hide Xcel rows or columns
Is there a way that rows and columns can be hidden in Xcel based on a formula.
Maybe a Yes/No selection somewhere cause certain rows and/or columns to be hidden
Web Development
Is there a way that rows and columns can be hidden in Xcel based on a formula.
Maybe a Yes/No selection somewhere cause certain rows and/or columns to be hidden
by carquiza
Hi,
Why not used a macro? Just insert this code:
Sub Macro1 ()
Selection.EntireColumn.Insert
Columns("D:D").Select
Selection.EntireColumn.Hidden = True
End Sub
The D:D is the column that you want to hide.
You can always create a button and put this macro on it. Hope this help you a bit.
Cheers,
Mel Arquiza
Home Page Design
http://hpd.welcome.to
This discussion is closed to new replies.
Sort by Trending