This question Object Required error when I clearly have an object was put on hold as off-topic even after it had generated two helpful answers (mine being one of them).
Please vote to re-open this question This question is a fundemental mis-understanding of the rules of Excel VBA as the OP thought they could use VB.net style
Workbook.SocialTransform! to reference the worksheet object. In Excel VBA the correct code is
Worksheets("SocialTransform") So how is this a typo? It is NOT a typo, it is a programming question that properly belongs on Stack Overflow. Please vote to re-open this question.
Maybe it's becoming popular to shoot at first-time posters, but I find that offensive. We were all beginners once.