"Tom Ogilvy" wrote in message ...
You are assigning an A1 style reference to a method looking for an R1C1
style reference.

DON'T use formulaR1C1, use formula

--
Regards,
Tom Ogilvy

Thanks Tom - I don't know why this wasn't excruciatingly obvious to
me. Works perfectly now, thanks for the help!

Thanks,
Brandon West