Is there a way via VBA to automatically select and cut all even columns in a table? I need to do this to tables with varying columns sizes, but would always need just the even columns copied..thanks much
ccdc, both PHV and Skip have good points. It would help if you explain the logic behind wanting to do this, AND we can possibly help more if you show us what you have tried so far.
Also, your request is not totally clear. On one hand:
"select and cut all even columns"
on the other hand:
"the even columns copied"
Cutting is one thing. Copying is another.
In either case...yes, VBA can do it.
Hint: each column has an index number. You can determine if it is odd or even using Mod 2.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.