Leslie -

If you need to incorporate some kind of test to determine which cells to include,
start with the entire range, and loop through to add the appropriate cells:

Dim rngCell as Range
Dim rngWholeRange as Range
Dim rngToChart as Range

Set rngWholeRange = Range("A1:A11")

For Each rngCell in rngWholeRange.Cells
If {rngCell passes the test} Then
If rngToChart Is Nothing Then
Set rngToChart = rngCell
Else
Set rngToChart = Union(rngToChart, rngCell)
End If
End If
Next ' rngCell

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

wrote:

I am trying to create a macro to select a range of cells from the same
row, but the columns may or may not be contiguous and the cell
references are not constant (they will change every month). Then use
this selection for the SetSourceData in a chart.

For example if I manually select the following using the CNTL key:
a1,a2,a3,a4,a5, a7,a8,a9,a10,a11 (as in a 2 weeks worth of data)
I would use this selection in the source for a chart.

Should I start the cell selection from Starting Point A and go through
a loop to select the necessary cells and place into an array? Or
should I use a set range command? I hope I am being clear. Any help
would be appreciated.

Thank you.

Leslie