Hi,

wondered if any of you kind souls could help me?

I'm writing a macro to take certain columns (containg last
name, first name and ID number) from one worksheet and
pastes them into another. This "table" is then sorted by
ID number, although some of the cells don't contain
numbers and the sort places them at the bottom end of the
list, so far so good.

I've got a sub to search through the ID number list until
it finds the first non-numeric entry and I want to then
create a selection from that cell back to the first cell
of the table (C4 in this case) and would imagine it's
something like

Range("currentcell:C4").Select

but for some reason I can't work out how to do this, and
it's probably so simple that I'll kick myself!

Oh, by the way, this procedure is to be run weekly and the
cell address of the first non-numeric entry will change
every time which is why i can't just specify a cell
address.

Help!

Thanks,

H.