LinkBack URL
About LinkBacks
Hi folks,
got stuck on this toggle button.
I am trying to hide Column D, F, K I
Please Login or Register to view this content.
how can i fix this - it does not work
error
Application.ActiveSheet.Columns(xAddress).Hidden = True
many thanks
sl
Hi folks,
got stuck on this toggle button.
I am trying to hide Column D, F, K I
Please Login or Register to view this content.
how can i fix this - it does not work
error
Application.ActiveSheet.Columns(xAddress).Hidden = True
many thanks
sl
ActiveSheet.Range("D:D,F:F,I:I,K:K").EntireColumn.Hidden = True
Ben Van Johnson
Re: Toggle Button -Show Hide Column Range Fails
Yikes,
no wonder I was going round and round
thank you very much
solved!
using your original syntax
change columns to range and add entirecolumn
Please Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
How bizarre,
i swear I tried something similar,
oh well, well at least I have 2 solutions should the toggle button play up -he he
thanks folks for your help
Actually,
the .EntireColumn.Hidden did the trick, well done
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks