Hi All,

I am creating a chart on userform from a table. It works perfectly when I select a range of data from two columns next to each other by using the following code:

rng = wsSource.Range("A10:B374")
But what I really want is to have a chart from data in column A and the last column. I have tried to be creative and used the following code but I am getting error message "Type Mismatched". any idea how can I define to select data of column A and the last Column?

rng = .Range(.Range(.Cells(10, "A"), .Cells(374, "A")), (.Range(.Cells(10, lc), .Cells(374, lc)))).Address
PS. I have defined lc as last column so everything works fine with the first code but don't really know how to select only column A and the last Col.

Thanks,