| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Deleting column in a worksheet that is not active worksheet
Could anyone please tell me (a) Why the following line of code will work only if "Test" is the active worksheet. Sheets("Test").Cells(1, 1).EntireColumn.Delete (b) How can I delete a column in a particular worksheet without selecting that worksheet. Thank you very much. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Basic Question - How do I return the worksheet number of the active worksheet? | Excel Programming | |||
| Active cell, row, column, worksheet, etc | Excel Programming | |||
| Report All Column Widths In Active Worksheet - Corrected | Excel Programming | |||
| Report All Column Widths In Active Worksheet - an example | Excel Programming | |||
| macro to apply worksheet event to active worksheet | Excel Programming | |||
Threaded Mode
