| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| delete value on worksheet 2 that match values on worksheet 1 | Excel Discussion (Misc queries) | |||
| Copy column header to next column, delete & delete every nth colum | New Users to Excel | |||
| Delete a Column when in a Macro-Worksheet Event? | Excel Worksheet Functions | |||
| How to delete a duplicate Excel worksheet within that worksheet? | Excel Discussion (Misc queries) | |||
| Find Column heading and then Delete entire column | Excel Programming | |||
Hybrid Mode
