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