I am running into an issue where I can hard code in a WorkBook and WorkSheet Names into a macro and it will run properly. But when I dim a variable(Workbook,Worksheet) and SET the objects I am unable or more less don't know how to reference those objects in a countIfS formula. Which Im not...