Ron,

Okay I got the range to accurately work. The problem was the first 2 rows
had merged cells in them. If I delete the merged cells it works fine. Which
I can make work.

Is there a way to get the search for the first blank row to ignore merged
cells or not start the search until Row 4? I tried changing the Range"A2" to
Range "A4", Range "A10" etc, but no luck.

Thanks!

Jason