VBA Sort 1004 Run-time error

Hi, I'm having problems with a sort macro I wrote


This Macro works. except that some numbers need to be stored as text so it doesn't sort properly . the # of columns are always the same but the row count is variable.

Please Login or Register  to view this content.

I tried changing the macro to

Please Login or Register  to view this content.

but now it gives me a 1004 run-time error.

I'm sure its just a simple error on my part but I can't for the life of me figure it out.

any help would be much appreciated.

Chris

Hello Chris,

Simple typo error.

Please Login or Register  to view this content.