Interesting!! You for sure hit the nail on the head with that one. Hiding that particular statement removes the issue outright.
- I tried the "DoEvent" command above it as in the MS forum link, but that did nothing.
- I've replaced SendKey with the CalculateFull method
Any idea what the purpose of it was? Looked like %^{F9} was setting up a shortcut key or something... what does CalculateFull do instead? Seems like it puts the previous code into "context" for Excel..?
Thanks, Bryan
|