title: Deleting more than 20 columns in excel vba
body: <p>I wrote a macro to do multiple things and in the end want to delete more than 20 columns.<br>
  I used the below statement to execute it but it gives me a run time error. It looks like there is a limit on how many columns you can delete at a time.</p>
  
  <p>I recorded a macro to delete all the below columns and it seems that excel is splitting the range statement into multiple but when i use it, it does not seem to work.  pls let me know what's the easiest way to delete so many columns. thanks</p>
  
  <pre><code>Range("A:A,C:C,D:D,E:E,F:F,J:J,L:L,M:M,O:O,Q:Q,R:R,T:T,U:U,V:V,W:W,X:X,Z:Z,AA:AA,AB:AB,AC:AC,AD:AD,AE:AE,AG:AG,AI:AI,AK:AK,AL:AL,AN:AN,AO:AO,AP:AP,AQ:AQ,AR:AR,AT:AT,AU:AU, AV: AV , AW: AW , AX: AX , AY: AY , AZ: AZ , BA: BA , BB: BB , BC: BC , BD: BD , BE: BE , BF: BF , BG: BG , BH: BH, BI:     BI , BJ: BJ , BK: BK , BM: BM , BN: BN , BP: BP , BQ: BQ , BR: BR , BS: BS , BU: BU , BV: BV , BW: BW , BX: BX , BY: BY , CA: CA, CB:     CB , CC: CC , CE: CE ").Select
  Range("CE1").Activate
  Selection.Delete Shift:=xlToLeft
  </code></pre>