Convert string to range

Hi all!
I'm am very new to vba programming and have limited knowledge of excel, which is not a good combination.. =) Anyway, i'm trying to make a chart using a selection of cells. I loop the sheet and add each cell address i want (i'm looking for cells containing a specific word, then grabbing the address of the adjacent cell that contains a number). So i have a string (tmpFull) that looks like this, only longer. Each of these cells contain a number.

$B$12,$B$13,$B$14,$B$15,$B$16,$B$17,$B$18,$B$19,$B$21,$B$22,$B$27

I then need to assign this to my chart, so i "convert" the string to a range, or at least i'm trying to, using

Please Login or Register  to view this content.

And then add it to my chart (FullDatesRng made the same way)

Please Login or Register  to view this content.

But no matter what i do, i end up with a 1004 error. I have tried building the string with different formats like B10,B11 or "B10,B11" and so on in different combinations but nothing works. Hoping for a pointer to what i'm doing wrong here.

Cheers!

mavve2004, welcome to the board please be sure to use CODE tags when posting VBA.
For more information about these and other tags, found here

It's also generally a good idea to post a meaningful location in your profile as there can be / are significant functional differences based on locale (delimiters, dates etc...)

Skip your first bit and then use:

Please Login or Register  to view this content.

The data range and series for a chart need to be rectangular ranges. No discontinous ranges are allowed.

You could put formulas like =B12 in a separate part of the worksheet in a rectangular range and use that as the source for the chart.