this line gives me an error:
firstboguscc = Application.CountIf(Workbooks("usertemp.xls").Worksheets("Sheet1").Range("AF"), crit)
I don't know why
firstboguscc is defined at a string
crit is defined as a string
If i use the line in the active worksheet like this:
firstboguscc = Application.CountIf(Range("AF"), crit)
it works fine. But if i want to count the instances of crit in another workbook, i get an "Application-defined or object_defined error" Must be in the syntax but I can't figure it out.