Solved

Macro debugging question

Posted on 2013-06-20
3
236 Views
Last Modified: 2013-06-20
I had an Excel macro created for me by an EE expert quite some time ago (see attached spreadsheet).  The macro copies and pastes selected datasets from the Dataset sheet onto the Select sheet and then generates a graph of the datasets based on the start and end dates I select.  I have run into a problem.  Even though the datasets now extend to May 2013, the macro only seems to recognize data through Feb 2013.  I've tried to resolve this but have failed.  Can someone please take a look at the macro and let me know why it doesn't recognize all of the months.

Thanks!
Beta.xlsm
0
Comment
Question by:pwflexner
3 Comments
 
LVL 45

Expert Comment

by:Martin Liss
ID: 39264504
Let me teach you how to fish:)
Ignore the title of my article. Almost all of it applies to VBA.
0
 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 250 total points
ID: 39264643
From the Formula menu go to the Name manager and extend the range for EndDate
0
 

Author Closing Comment

by:pwflexner
ID: 39264682
Perfect, thanks!
0

Featured Post

IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Excel  Worksheet Relationships 7 25
Thanks for the advise, but... 4 24
Excel Array formula issues 4 13
excel time calculation 11 22
Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
Workbook link problems after copying tabs to a new workbook? David Miller (dlmille) Intro Have you either copied sheets to a new workbook, and after having saved and opened that workbook, you find that there are links back to the original sou…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…

760 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now