Thank you for taking the time to respond to my post and upload some code. I apologize for not providing a document to work with. In addition, re-reading my post, I see I wasn't terribly clear about the issue.

This lack of clarity hints at the problem: I was tired. I miscounted the columns, the offset value was therefore incorrect, and the macro instead tried to activate a cell with a formula in it, which wouldn't activate, for some reason. I've adjusted the offset and the macro now works.

Thanks again for your reply. The added lesson here for me is, always upload a file.