Hi all, I've been literally for a few hours and can't figure this out with multiple multiple google searches.

I'm trying to create multiple graphs from vba. Each graph will potentially have different ranges and I'm running the "create graph function" in a loop with other data. I need to define the range in which the different graphs select their data from within these loops. That's why I can't define it like this, for example:

ActiveChart.SetSourceData Source:=Sheets("Ignore This").Range("A3 : D4"), PlotBy:=xlRows

I want to define them like this:

ActiveChart.SetSourceData Source:=Sheets("Ignore This").Range(Cells(3, 2), Cells(4, 13)), PlotBy:=xlRows

where the numbers would be replaced by variables which are looped using for/next.

I'll post the code if necessary but I think it is merely syntax in nature and therefore I just need to know how to select a range using cells by number!

Thanks in advance!