Thread: Macro Error
View Single Post
  #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