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?
Bookmarks