Hi,
There are previous posts about this but quite old and I have been unable to get them to work without getting Run-time error '9': Subscript out of range. Hoping someone will be able to assist. The objective is to generate an email which includes the chart (Chart 1) from Sheet2 into the body of an email with pre written text (to be decided upon).
Any assistance would be greatly appreciated.
Please Login or Register to view this content.
HTML Code:
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Thanks KOKESEK, but I'm still getting the same error. My code is below. I'm sure it's something simple but I'm missing it.
Please Login or Register to view this content.
What line generates error? Did you check path in general? Privileges to write into declared path? etc.
Last edited by KOKOSEK; 11-06-2019 at 09:18 AM.
Hi KOKOSEK, I knew it would be something stupid. I had renamed the sheet but it was still being referenced by the old name. Corrected and now it works. Perfect. Thanks for the help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks