Hi Jim

Send me your test workbook (private)
I will look at it then

--
Regards Ron de Bruin
http://www.rondebruin.nl


"jim hensen" wrote in message ...

ok... i see the problem. The thing is the station number is in column
B. Sorry i neglected to mention that. I tried switiching the
A1:A100 to B1:B100. I still cant seem to get it working. I pasted
your code in and saved it in a macro. Then when i run the macro it
does nothing. Sorry for all the trouble im kinda new to this.


--
jim hensen
------------------------------------------------------------------------
jim hensen's Profile: http://www.excelforum.com/member.php...o&userid=15155
View this thread: http://www.excelforum.com/showthread...hreadid=268890