Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
We want to delete a column in a workbook without
activating the workbook. The code below is supposed to check whether cell A1 is null. If it is, we want to delete column A from the workbook without activating that workbook, but can't get the syntax right. (The Test workbook has only one workshet.) If Workbooks("Test.xls").Range("A1") = "" Then Workbooks("Test.xls").Columns("A").Delete End If Help, please. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
deleting workbook | New Users to Excel | |||
Deleting Workbook from others | Excel Worksheet Functions | |||
deleting macros that are not really in my workbook? | Excel Worksheet Functions | |||
How do I prevent someone from deleting a workbook? | Excel Discussion (Misc queries) | |||
Deleting Workbook | Excel Programming |