View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
EXCELMACROS EXCELMACROS is offline
external usenet poster
 
Posts: 43
Default COLLECTION question

Hi, I have over 200 columns, I want to do a for next loop to delete the
unwanted columns, at the end I should only end with 50 columns. does anyone
have an example where I can find my columns on a collection and if is there
skip it if is not then delete entire column?

I want to avoid using a Range("A:A, D:D....").delete as there is 50 columns
I'm keeping.

Thanks,
--
Thank you...