Yeah, I noticed the error right after I posted this question. So the formula as it would be written is how you have it shown (without the application.worksheet, etc) and if I write it that way I still get the same error. Maybe I'm not understanding?