Thank you Bob for your help. When I run it I get an error at :With Range("C1").Resize(.Count, 2)
I am running excel 2013, if that makes any difference.
But that is what i am looking for. Again thanks and Happy holidays!