Don’t Force It
If you get stuck, there are a number of ways to resume your progress:
Try turning on macro recording (Tools → Macros → Record a New Macro), performing the task in Excel, and then turning off recording and examining the code that Excel generates.
Search MSDN (http://www.microsoft.com/msdn) to see if Microsoft has addressed your problem.
Search newsgroups (http://groups.google.com/groups) to see if someone else has solved your problem.
And of course, you can always check http://excelworkshop.com to see if I’ve solved the problem!
If something still seems too difficult, examine your approach. I generally go fishing in that situation and come back to the problem later. If you don’t live somewhere with good fishing, I guess you’re just stuck.
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access