Method 'Columns' of object '_Global' failed
 

In a normal Sub in a normal module (not run via automation) I have this line
of code:
Columns(8).NumberFormat = "@"
Actually it is:
3260 Columns(8).NumberFormat = "@"
As I have line numbering for error handling.

It works fine on my machine (Excel 11, Windows XP) but I got a message from
one user
where this line fails with: Method 'Columns' of object '_Global' failed
This is also in Excel 11, not sure about the OS.
Why could this be?

If I record selecting a column I get: Columns("E:E").Select
and Columns is a member of globals in the object browser.
Should I do: ActiveSheet.Columns(8) ?

Thanks for any insight in this.

RBS

Method 'Columns' of object '_Global' failed
 

Being that it is in a normal module it will by default be running against the
active sheet. If the active sheet at the time is a Chart sheet and not a
regular worksheet you will generate the error posted. Columns is not a
property of method of a chart sheet... That's my best guess...
--
HTH...

Jim Thomlinson


"RB Smissaert" wrote:

In a normal Sub in a normal module (not run via automation) I have this line
of code:
Columns(8).NumberFormat = "@"
Actually it is:
3260 Columns(8).NumberFormat = "@"
As I have line numbering for error handling.

It works fine on my machine (Excel 11, Windows XP) but I got a message from
one user
where this line fails with: Method 'Columns' of object '_Global' failed
This is also in Excel 11, not sure about the OS.
Why could this be?

If I record selecting a column I get: Columns("E:E").Select
and Columns is a member of globals in the object browser.
Should I do: ActiveSheet.Columns(8) ?

Thanks for any insight in this.

RBS

Method 'Columns' of object '_Global' failed
 

Yes, that is the only thing I can think of.
Or, as this code is in an add-in it could be that no workbook is open, so
there
is no sheet at all.
Waiting for confirmation from this customer.

RBS


"Jim Thomlinson" wrote in message
...
Being that it is in a normal module it will by default be running against
the
active sheet. If the active sheet at the time is a Chart sheet and not a
regular worksheet you will generate the error posted. Columns is not a
property of method of a chart sheet... That's my best guess...
--
HTH...

Jim Thomlinson


"RB Smissaert" wrote:

In a normal Sub in a normal module (not run via automation) I have this
line
of code:
Columns(8).NumberFormat = "@"
Actually it is:
3260 Columns(8).NumberFormat = "@"
As I have line numbering for error handling.

It works fine on my machine (Excel 11, Windows XP) but I got a message
from
one user
where this line fails with: Method 'Columns' of object '_Global' failed
This is also in Excel 11, not sure about the OS.
Why could this be?

If I record selecting a column I get: Columns("E:E").Select
and Columns is a member of globals in the object browser.
Should I do: ActiveSheet.Columns(8) ?

Thanks for any insight in this.

RBS