macro to sort varying number of rows

Hi!
I need help creating an Excel macro that will select (highlight) a varying number of rows, beginning with row 2. The number of rows to be selected will always be defined in cell K1. For example, if cell K1 contains the value 24, the macro would select rows 2:25. If the value of cell K1 is 14, the macro would select rows 2:15.

If it makes any difference, I'm using Excel 2003. Anyone out there that can help me with this?

Thanks, in advance!
Kathy

Thank you! That worked beautifully! Of course, you already knew it would work, but I am grateful for the quick reply!

Thanks!
Kathy