Hello,
I have a worksheet which contains hundreds of columns.
I only need some of them so, I want to delete the ones I don't need.
I have saved the column numbers I need, in an array called ArrayCol (For example: 5, 7, 10, 3, 15.......)
I need a macro which would delete all the columns except those listed in ArrayCol.
Could you please advise?
Thanks
Hello,
yes but as the attachment is missing …
Hi Plans,
You need to set a For Next loop starting at the largest column number and use a "Step -1" to see if the column you are on is in your array. If it isn't you need to delete that column with a :=Shift xlToLeft.
It would be easier if you supplied a sample workbook.
I'd also use a Split(",","5,7,10,3,15) to get your column numbers into your array.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
???Originally Posted by plans
Please Login or Register to view this content.
or use CHOOSECOLS in a simple formula??
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Thank you mjr veverka!
It works for me.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks