Referring to a Variable Range of Columns for the SetSourceData Method

**DobbsHead** · 11-29-2012, 02:02 PM

So, I'm trying to generate charts automatically. My data is imported from CSV, and there are a variable number of columns of data. I count the number of columns of data I want to plot. Now all I need is to refer to those columns by number such that I return a range holding all the data I want to plot. My code is of the form:

Please Login or Register  to view this content.

I've tried a few things, detailed below with the given error codes

Please Login or Register  to view this content.

I'm sort of at a loss as what to do. Any thoughts?

**DobbsHead** · 11-29-2012, 03:56 PM

Well, I solved the problem and feel like a fool. The issue was how I was passing .SetSourceData the range object. VBA is inconsistent about how it like to pass range objects. Example:

Please Login or Register  to view this content.

So yeah, the problem is solved. Hope this helps somebody else with the same issue.

Referring to a Variable Range of Columns for the SetSourceData Method

LinkBack

Thread Tools

Rate This Thread

Display

Referring to a Variable Range of Columns for the SetSourceData Method

Re: Referring to a Variable Range of Columns for the SetSourceData Method

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions