I need a toggle button that will hide any column in which row 38 is empty Between the columns "E" and "T" then when unclicked shows all the columns between "E" and "T"
simple enough but I cannot get the toggle to recognize the difference between empty and filled cells.
will this do?
Sub test() Dim Cell As Range For Each Cell In Range("E38:T38") If IsEmpty(Cell) = True Then Cell.EntireColumn.Hidden = Not Cell.EntireColumn.Hidden End If Next Cell End Sub
Last edited by Bishonen; 10-05-2012 at 03:16 PM.
If you think that my answer was helpful, please click on the "Add to this user's Reputation" button.
Yes, thank you.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks