View Single Post
Old 03-07-2021, 11:55 AM
Peterson Peterson is offline Windows 10 Office 2019
Competent Performer
Join Date: Jan 2017
Posts: 133
Peterson is on a distinguished road

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.
Reply With Quote