Delete every nth column from the worksheet
 

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.

Delete every nth column from the worksheet
 

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)

wrote in message
oups.com...
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.