#1   Report Post  
Posted to microsoft.public.excel.misc
The Toasterman
 
Posts: n/a
Default Macro Error

I get the following error messge when I run a MACRO

Run-time error 1004
Sort Method of range
Class failed

It only appears on certain machines, the macro runs ok on others.

Any ideas
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student
 
Posts: n/a
Default Macro Error

post it
--
Gary''s Student


"The Toasterman" wrote:

I get the following error messge when I run a MACRO

Run-time error 1004
Sort Method of range
Class failed

It only appears on certain machines, the macro runs ok on others.

Any ideas

  #3   Report Post  
Posted to microsoft.public.excel.misc
The Toasterman
 
Posts: n/a
Default Macro Error

post what? The MACRO or the error?

"Gary''s Student" wrote:

post it
--
Gary''s Student


"The Toasterman" wrote:

I get the following error messge when I run a MACRO

Run-time error 1004
Sort Method of range
Class failed

It only appears on certain machines, the macro runs ok on others.

Any ideas

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Macro Error

The relavant portion of the macro that has the error--and indicate which line
causes the error.

And if your code depends on what's in variables/cells, share those values, too.

The Toasterman wrote:

post what? The MACRO or the error?

"Gary''s Student" wrote:

post it
--
Gary''s Student


"The Toasterman" wrote:

I get the following error messge when I run a MACRO

Run-time error 1004
Sort Method of range
Class failed

It only appears on certain machines, the macro runs ok on others.

Any ideas


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
The Toasterman
 
Posts: n/a
Default Macro Error

Just posted the MACRO below, the error appears in the SELECTION line, 2nd
line down.

"Dave Peterson" wrote:

The relavant portion of the macro that has the error--and indicate which line
causes the error.

And if your code depends on what's in variables/cells, share those values, too.

The Toasterman wrote:

post what? The MACRO or the error?

"Gary''s Student" wrote:

post it
--
Gary''s Student


"The Toasterman" wrote:

I get the following error messge when I run a MACRO

Run-time error 1004
Sort Method of range
Class failed

It only appears on certain machines, the macro runs ok on others.

Any ideas


--

Dave Peterson

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error from losing power while writing macro. Recovery help? MSgtMark Excel Discussion (Misc queries) 2 February 2nd 06 10:35 PM
MS Visual Basic Error...from MAcro G118 Excel Discussion (Misc queries) 0 December 12th 05 05:56 PM
Macro time out error mike b Excel Worksheet Functions 1 December 10th 05 05:21 PM
Macro / Compile Error / Duplicate Declaration carl Excel Worksheet Functions 1 June 29th 05 08:55 PM
Runtime error for macro that works in workbook created in Crystal Excel Discussion (Misc queries) 1 June 22nd 05 08:43 PM


All times are GMT +1. The time now is 12:04 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"