Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore First row
I am trying to delete some columns programmatically. I have been recording a
macro and then editing the code. This is the code I am using: Columns("E:G").Select Range("E2").Activate Selection.EntireColumn.Hidden = True This works fine for the macro. When I go to rerun it, it fails. If I delete the top merged heading row then it works. This heading gets automatically created from another program so I can't delete it but I want my code to ignore the top row when deleting the columns programmatically I hope I am making myself clear. And I hope that someone can help me out. Cheers Bec |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
ignore #n/a | Excel Discussion (Misc queries) | |||
ignore #N/A in a sum? | Excel Worksheet Functions | |||
IF to ignore #N/A | Excel Discussion (Misc queries) | |||
please ignore | Excel Worksheet Functions | |||
Ignore #DIV/0! | Excel Worksheet Functions |