LinkBack URL
About LinkBacks
Is there anyone who can help suggest as to what is causing the break or help read the attached code?
I keep breaking on "Set .."
Is there anyone who can help suggest as to what is causing the break or help read the attached code?
I keep breaking on "Set .."
Last edited by wanian7; 08-01-2015 at 11:18 PM.
my assumption is that Sheets(sScenarioID) Doesn't exist...
!If all your troubles are solved, then so is the thread. Show this by marking it so using thread tools at the top of the page.
If I helped do this, then please show your appreciation by awarding rep points.
<------ Button for that is over there
What is wbTGS. ?
I think your on to it. Are you using Option Explicit to help ensure you declare all variables.Originally Posted by JOHN H. DAVIS
Should wbTGS actually be wbCS which is the Workbook?
Please upload a sample of your workbook, not a picture of your data (especially side-ways pics). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you
Also, not all members can upload picture files (Company firewalls and stuff) - and, depending on what browser is being used, some pics dont even show up on the forum
Your workbook should show a small desensitized example of the data you are working with and a manual mockup of the expected results.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
This answered the question!!! Thanks so much PTmukloon.
Hi FDibbins - So sorry that was no a lazy stunt out on my part. I was in school and the firewall kept rejecting my copying and pasting of the data.
Its now resolved. I really appreciate your post and will definitely be sensitive to the points raised.
Kind regards,
Ian
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks