I'm looking to plot a graph of certain ranges of data. The ranges are defined as follows:

Range("A1:A10, B1:B10, F1:F10")

However, I am not hard coding this and need to reference the columns using the column index instead of a letter. I therefore need an equivalent to this function using the Cells method because Cells refers to Columns using an index instead of a letter.

Range(Cells(1, 1), Cells(10, 1))

This defines one area of cells, but I need to define another area aswell and I do not know how to do this.

any ideas anyone?