Jay,

Glad to help. If you're new to VBA, remember that the cell references are
Cell(row,column), not "column"-"row" like you're used to (ex A1, B12).
That little slip can cause hourse of frustration (experience talking, here).
;-)

Jon

"sa02000" wrote:


Jon, Thank for the code. I looked through the code and looks like its
exactly what I was looking for. I have my data scattered into different
columns and data starts at row 8.(one sheet 1). Those columns are not
next to each other either. Those columns are A,C,D. I think I should be
able to adjust the code to look for those columns.

Thanks again.
Jay


--
sa02000
------------------------------------------------------------------------
sa02000's Profile: http://www.excelforum.com/member.php...o&userid=27747
View this thread: http://www.excelforum.com/showthread...hreadid=555672