Thread: Delete every 2nd column from fixed starting point
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
  
Posts: 11,272
Default Delete every 2nd column from fixed starting point
For i = 26 To 6 Step -4
Columns(i).Resize(, 2).Delete
Next i

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Darin Kramer" wrote in message
...
Howdie,
Can anyone help with VB to do the following: I would like to delete
columns F and G, then skip H and I, delete j and k, skip l and m, delete
n and o etc

So basically starting at F delete two columns, skip two columns, delete
two columns etc until no more data in the columns...

Thanks guys, appreciate your help

Regards

D



*** Sent via Developersdex http://www.developersdex.com ***


Reply With QuoteReply With Quote