Sorting records with a macro

Excel253
Hi,



Thanks in advance.



I which to create a macro button that selects all rows (after row 10) that

col b is completed with a number. (With the intention of sorting it later.)



When I write the macro is states the no of rows I have selected. The trick

is I don't know how may rows there are so how do I select just active rows.



Thanks



Trev


-