Your s1= ... is almost right. Just put a Set at the front of the statement. E.g.Set s1=worksheets("input")