Set is how you set up object variable. If you use the set with out declaring a variable as object, you get an error, as non object variable could not be set againt a set which is an object. So, declare your variables as objects, like range, worksheet, workbook and use the set word to set up the object variable. In short, set is used with objects.