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