We help IT Professionals succeed at work.
Get Started

Identify which columns in a datasheet are selected

Dale Fye
Dale Fye asked
Last Modified: 2013-11-28
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.
Watch Question
Most Valuable Expert 2014
This problem has been solved!
Unlock 2 Answers and 3 Comments.
See Answers
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