Selection & Sorting

[NTB]

Hi,

I have 2 set of data in one sheet, separated by a blank row.
I would like to select & sort by column A everything A:C before the blank row
The amount of lines is vary month to month between the sets, so if I could select to the line above the blank row then it would be nice.

Thank you for your help!

[StephenR]

Just click anywhere in the top range and sort. It automatically stops at a blank row.

[NTB]

I was afraid of this as it seems to be a simple task. However, this portion of code will be intergrated into a Macro file that I am currently working on.

To spare everyone from having to go thru everything, I simplied it down. I hope you can help me with the code.