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

Ignore First row
 

You can't hide just part of a column.............all or nothing


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 08:28:01 -0700, Bec wrote:

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

Ignore First row
 

I am trying to hide the entire column. It works fine when I record the macro.
No problem and I don't have to delete the top row. But when I run the macro
it doesn't work. It deletes all my columns. After hours or fiddling I tried
deleting the top row and running the macro again and it worked. But I can't
delete the top row generally as it keeps getting regenerated anyway. So I
need a way to run the macro with ignoring the top row.

It's weird because it does work when I first record the macro so obviously
excel knows to ignore the top row then just not when it reruns the macro



"Gord Dibben" wrote:

You can't hide just part of a column.............all or nothing


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 08:28:01 -0700, Bec wrote:

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

Ignore First row
 

Your code is not deleting columns, it is hiding Columns E through G

I guess I don't understand what you mean by "ignoring the top row".

When hiding or deleting columns you cannot ignore the top row or those columns.


Gord

On Fri, 18 Jul 2008 08:48:00 -0700, Bec wrote:

I am trying to hide the entire column. It works fine when I record the macro.
No problem and I don't have to delete the top row. But when I run the macro
it doesn't work. It deletes all my columns. After hours or fiddling I tried
deleting the top row and running the macro again and it worked. But I can't
delete the top row generally as it keeps getting regenerated anyway. So I
need a way to run the macro with ignoring the top row.

It's weird because it does work when I first record the macro so obviously
excel knows to ignore the top row then just not when it reruns the macro



"Gord Dibben" wrote:

You can't hide just part of a column.............all or nothing


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 08:28:01 -0700, Bec wrote:

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

Ignore First row
 

Hi Gord,

Apologies for teh confusion I did mean hide not delete. The problem is you
can actually do it. I can do it manually all the time and it performs fine
but as soon as you go to rerun what I've just recorded it doesn't work. So it
does in fact hide the column and ignore the first row when you do it manually
but not programmatically. That's the bit that has stumped me.

Cheers
Bec

"Gord Dibben" wrote:

Your code is not deleting columns, it is hiding Columns E through G

I guess I don't understand what you mean by "ignoring the top row".

When hiding or deleting columns you cannot ignore the top row or those columns.


Gord

On Fri, 18 Jul 2008 08:48:00 -0700, Bec wrote:

I am trying to hide the entire column. It works fine when I record the macro.
No problem and I don't have to delete the top row. But when I run the macro
it doesn't work. It deletes all my columns. After hours or fiddling I tried
deleting the top row and running the macro again and it worked. But I can't
delete the top row generally as it keeps getting regenerated anyway. So I
need a way to run the macro with ignoring the top row.

It's weird because it does work when I first record the macro so obviously
excel knows to ignore the top row then just not when it reruns the macro



"Gord Dibben" wrote:

You can't hide just part of a column.............all or nothing


Gord Dibben MS Excel MVP

On Fri, 18 Jul 2008 08:28:01 -0700, Bec wrote:

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