We help IT Professionals succeed at work.
Get Started
Identify which columns in a datasheet are selected
I'm exporting a datasheet to Excel via vba thanks to Nick67 and Capricorn1. In that code, I exempt those columns from the datasheet that have been hidden by the user. Now I would like to take that one step further and only export the columns that have selected by the user. For example, if the user selects several columns that are next to each other and only want to export them.
Is there a way to identify which columns are selected? I assume so, since the Find functionality works on "selected" columns. I just have not been able to identify the specific property of the datasheet or of the controls collection to identify.
Is there a way to identify which columns are selected? I assume so, since the Find functionality works on "selected" columns. I just have not been able to identify the specific property of the datasheet or of the controls collection to identify.
Why Experts Exchange?
Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.
Jim Murphy
Programmer at Smart IT Solutions
When asked, what has been your best career decision?
Deciding to stick with EE.
Mohamed Asif
Technical Department Head
Being involved with EE helped me to grow personally and professionally.
Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question
Connect with Certified Experts to gain insight and support on specific technology challenges including:
- Troubleshooting
- Research
- Professional Opinions
Did You Know?
We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE