Issue with Sort

[Guest]

You need to use ".Range" to ensure you utilise the with statement...

 

[Guest]

I think you need to use ".range" so that the "with" is used....

 

[Guest]

Robert,
Thanks very much for the response. I think I mentioned that I'm relatively
new to excel, so with that being said I have to admit that I don't have the
skillset to follow your instruction of recording a macro. I can begin
recording a macro, but once I open the function it's all forgeign to me. I
have no idea what to do from there. Is there a step-by-step instruction
anywhere that you are aware of that can walk me through the basics of this
macro? I don't even know where to enter code, other than each specific cell
or range..but even then I don't have much of a comfort zone.

 

[Guest]

hi,
I think you crated the error when you removed the select actions. in your
edited code, you do specify the sheet to sort but not the range to sort.
Unless the curser is in the range to sort, excel does not know what to sort.
try an experiment. click a nonadjacent blank cell to the right of your data
and try to sort you data. oops

Regards
FSt1