Column Sort Macro 1004 error....

Why does this code keep giving me a 1004 Error...I am trying to sort all the data in Column B...

Please Login or Register  to view this content.

Hello zapacoman,

Welcome to the Forum!

Since your keyword is in row 2 of column "B", I am assuming row 1 contains headers. If so then use this code...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

Leith,
Thanks for the help, but unfortunately the same 1004 error is coming up with the code you suggested:

Please Login or Register  to view this content.

Hello zapacoman,

Can you post your workbook for review?

Sincerely,
Leith ross

See attached, Thank You!

Hello zapcoman,

Strange, all your sort macros are working fine on my machine. I am running Windows Xp with Excel 2003. I don't know why it isn't working on your end.

Sincerely,
Leith Ross

Ditto, ditto, ditto.