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

--
jim hense
-----------------------------------------------------------------------
jim hensen's Profile: http://www.excelforum.com/member.php...fo&userid=1515
View this thread: http://www.excelforum.com/showthread.php?threadid=26889