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), perform the task in Excel, then turn off recording and examine the code that Excel generates. Search MSDN ( www.microsoft.com/msdn ) to see if Microsoft has addressed your problem. Search newsgroups ( groups.google.com/groups ) to see if someone else has solved your problem. And, of course, you can always check www.oreilly.com/catalog/exceladn or www.mstrainingkits.com to see if I've solved the problem!
If something still seems too difficult, examine your approach. In that situation, I generally go fishing and come back to the problem later. If you don't live somewhere with good fishing, I guess you're just stuck. |