Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
delete columns based on value in one cell
Excel 2003 - I am trying to delete columns A through D based on the value of
cell 1, column IT: If cell 1, column IT = 65536, delete columns A through D This is what I have come up with: Sub DeleteColumns() If Cells("1,IT") = "65536" Then Columns("A:D").delete End If End Sub I get a run time error 13, type mismatch. I have tried using column numbers instead, but am still having no luck. (huge file, lots of mixed data I'm filtering using columns IS and IT) Thank you so much for any help you can give. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete columns based on cell value | Excel Programming | |||
Delete Row Based On Two Columns | Excel Programming | |||
How can I delete a row based on Columns H and I | Excel Programming | |||
How can I delete a row based on Columns H and I | Excel Programming | |||
Delete Columns based on a condition | Excel Programming |