Hey everyone;
Kind of a continuation off of the previous thread found here:
http://www.excelforum.com/excel-prog...olumn-vba.html
For those not involved in the previous question, UR and UC are Row/Column counts from earlier parts in my worksheets, both Integers.
I've accomplished fully populating the range of information, and now I'm working on the creation of the graph based upon that information...
For some reason, the use of the Cells command doesn't seem to function similarly with the filldown command that we made earlierActiveChart.SetSourceData Source:=Sheets("Graph Reference Area").Range("A2", Cells(UR, UC + 1)), PlotBy:=xlColumns
I get 1004: Application-defined or Object-defined error. Any insight?
Last edited by Miraun; 06-28-2011 at 01:38 PM.
I '<3' reputation. If I helped, click the scales. This will be helping an internal departmental competition with co-workers.
Reputation can be granted through the Scales Icon (for classic layout), or the little Star on the bottom of the post next to the blogging function for the new forum layout.
If you're not busy, and really feel down on life, read my excel blog which may or may not have contents.
Using Resize command made it work... not sure why Cells didn't work though...
Either way, marking it closed.
I '<3' reputation. If I helped, click the scales. This will be helping an internal departmental competition with co-workers.
Reputation can be granted through the Scales Icon (for classic layout), or the little Star on the bottom of the post next to the blogging function for the new forum layout.
If you're not busy, and really feel down on life, read my excel blog which may or may not have contents.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks