Post your code OR if you have set Option Explicit then add

Dim cell as range

to the macro.

"jhahes" wrote:


Hi Toppers, I tried your solution and it made me debug. It stated
variable not defined with the word cell highlighted in yellow.

Duke, I also tried your solution and it gave me a debug error of type
mismatch with .offset(x,0).value highlighted in yellow.


Can you please help...


Thanks...

Josh


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=524984