Method 'Columns' of object '_Global' failed

[RB Smissaert]

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

 

[Jim Thomlinson]

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...

 

[RB Smissaert]

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