asked on need hide unhide column
have data in columns from column like this
![111222.PNG]()
then need an button to hide
columns
![111222AAA.png]()
the sequence will continues all over the worksheet
Ad_76984--1-.xlsm
then need an button to hide
columns
the sequence will continues all over the worksheet
Ad_76984--1-.xlsm
Microsoft OfficeMicrosoft ExcelMicrosoft ApplicationsProgrammingVBA
Last Comment
ADRIANA P
SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
I wasn't sure where you wanted the button, but you can drag it where ever you want it.
29075969.xlsm
29075969.xlsm
ASKER
like these![111222AAA.png]()
ASKER
Martin Liss Thanks !
Glad to see you back
need to hide or unhide
but an sequence will be the sequence begings in column b then 31 columns sequence follow
then need to hide or unhide from 26 to 31 in the sequence
Glad to see you back
need to hide or unhide
but an sequence will be the sequence begings in column b then 31 columns sequence follow
then need to hide or unhide from 26 to 31 in the sequence
ASKER
shums great job !
but need to have the sequence all over the worksheet
but need to have the sequence all over the worksheet
See if this is better.
29075969a.xlsm
29075969a.xlsm
If you don't want column "A" hidden then use this one.
29075969b.xlsm
29075969b.xlsm
Note that in post ID: 42419679 I had the wrong file. I corrected it now.
ASKER
Martin after i hit the button i get this
![11223344.PNG]()
Uncomment the first "For lngCol = 1 to...." line.
ASKER
ASKER
Martin i dont understand this
how i do that ??
![4444.PNG]()
how i do that ??
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Shums Great Expert best Expert !!
Martin Liss Great JOB expert
Martin Liss Great JOB expert
i have an situation
need to hide all columns in blue color area not just the the firts
all over the worksheet ( will be added as needed)