Create Chart VBA

[hanif]

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:

Please Login or Register  to view this content.

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?

Please Login or Register  to view this content.

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,

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[hanif]

Thanks John. I tried this it gaves me an error but I added Set before rng=.... and worked perfectly.

Thanks for your help.

[JOHN H. DAVIS]

Good catch. I overlooked that. You're welcome. Glad to help out and thanks for the feedback.