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

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

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

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

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