Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Method 'Range' of object '_Global' failed | Excel Programming | |||
Method 'Range' of object '_global' failed | Excel Discussion (Misc queries) | |||
method 'range' of object '_global' failed | Excel Programming | |||
Method 'Intersect' of object '_Global' failed | Excel Programming | |||
Method 'Range' of object '_Global' failed | Excel Programming |