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
|