Ranges & SetSourceData

Hello,

I'm trying to reduce work by creating a macro to create charts from a worksheet. Each worksheet may have a different number of rows of data, so I first determine the last row of data then create ranges based on which columns i want to use. This is snippet of the code i'm trying to use:

Please Login or Register  to view this content.

The problem I'm having is trying to use a range variable in SetSourceData vs. hard-coding. Hard-coding ranges works, but since each worksheet may have different rows I need to use a variable. Is there an easier way to do this?

Thanks for your help

Hi

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Also, just be sure it is taking the variable ranges, comment out the line

Please Login or Register  to view this content.

rylo