Using a variable to select data for plotting

Hey all,

I am creating a macro that would access a number of workbooks and plot similar graphs in all of them. I am looking to use the bit of code generated by Excel, that I have included below, in my Macro.

Please Login or Register  to view this content.

My problem now is that the number of rows differ in each workbook. So I have added the following to count the number of rows:

Please Login or Register  to view this content.

Now I would like to use the variable lr in the code that creates the plot (to replace 64), but I am unsure of how to do this.

Any help would be really appreciated.

Thanks in advance

Lovi