VBA Code Revision (Involving Hiding of Columns)
Hello Experts!
I recorded a macro, that hides a group of columns. While this is only two lines of code, I was wondering - is there an even more stream lined way of saying it? Is it possible to do the same thing, with only one line of code?
Thank you in advance for your help! :)
I recorded a macro, that hides a group of columns. While this is only two lines of code, I was wondering - is there an even more stream lined way of saying it? Is it possible to do the same thing, with only one line of code?
Thank you in advance for your help! :)
Option Explicit
Sub HideColumns()
Columns("J:AB").Select
Selection.EntireColumn.Hidden = True
End Sub
Hi,
Since you already use columns you do not have to specify entirecolumn
Sub HideColumns()
Columns("J:AB").Hidden = True
End Sub
Regards
Since you already use columns you do not have to specify entirecolumn
Sub HideColumns()
Columns("J:AB").Hidden = True
End Sub
Regards
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
OP wants one line of code.
Wilder your's would be
gowflow
Wilder your's would be
Sub HideColumns()
If Columns("J:AB").Hidden = True Then Columns("J:AB").Hidden = False Else Columns("J:AB").Hidden = True
End Subgowflow
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thums up Rgonzo !!!!
didn't know that one, we never cease to learn :)
gowflow
didn't know that one, we never cease to learn :)
gowflow
wow, this is very good :)
Its even possible without VBA.
Select the columns to be hidden and go to the Data Menu and select Group. This will then add little bullets in the top margin above the columns and a button in the margin above the column to the right of the last column selected (AC in this example). This button will change Automatically for use to Hide or Unhide the columns.
The Grouping settings can be changed such that the button appears to the left of the Group if so required.
This Grouping function is particularly useful if the column before/after those selected is a Summary of the selected columns.
Thanks
Rob H
Select the columns to be hidden and go to the Data Menu and select Group. This will then add little bullets in the top margin above the columns and a button in the margin above the column to the right of the last column selected (AC in this example). This button will change Automatically for use to Hide or Unhide the columns.
The Grouping settings can be changed such that the button appears to the left of the Group if so required.
This Grouping function is particularly useful if the column before/after those selected is a Summary of the selected columns.
Thanks
Rob H
ASKER
Thank you everyone for your input!
I loved seeing this code get smaller and smaller, and even more advanced (show & hide).
@ Wilder1626 - Your solution worked great! :)
@ Rgonzo1971 - Looking through all of the solutions provided, ultimately I decided to go with your solution. Short code, and better yet - code I am able to read through & understand. :)
How should I award points?
I'm not sure if I should award points to first correct answer? Or the answer that ultimately I will be using that will work best for my situation.
What is the proper way to award points?
Again, thank you all for your solutions!
I loved seeing this code get smaller and smaller, and even more advanced (show & hide).
@ Wilder1626 - Your solution worked great! :)
@ Rgonzo1971 - Looking through all of the solutions provided, ultimately I decided to go with your solution. Short code, and better yet - code I am able to read through & understand. :)
How should I award points?
I'm not sure if I should award points to first correct answer? Or the answer that ultimately I will be using that will work best for my situation.
What is the proper way to award points?
Again, thank you all for your solutions!
Just do this:
Open in new window