Delete every nth column from the worksheet

G

garyusenet

Hello I want to delete every nth column from a worksheet

can someone tell me how this is done please.


thanks.

p.s. can someone also tell me how to select every nth column.
 
B

Bob Phillips

For i = 100 to 1 step -5
Columns(i).Delete
Next i

adjust to suit

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

match nth occurence 3
Copy every nth row into a new worksheet 6
Extracting the Nth element from a String 1
Macro to delete specific rows in different worksheets 5
Excel 2003 Markers 5
how to copy every nth column of a row to the first cell of the row? 1
Sum of every nth cell in a column 3
VBA Debug Mode : How to I enter it after executing the nth data row. 1

Top