Hi,
I have some basic code to create charts from a datasheet. The line which references the data source looks like this:

.Chart.SetSourceData Source:=datawkb.Sheets(sheetnames(i)).Range("$B$2:$C$2,$E$2,$G$2,$I$2,$K$2,$B$95:$C$97,$E$95:$E$97,$G$95:$G$97,$I$95:$I$97,$K$95:$K$97,$B$102:$C$102,16,$G$102,$I$102,$K$102")
I'm trying to figure out if I can replace some of those cells with previously declared variables or just numbers. So instead of G102, I can use Var1 instead, which might be the sum of a few other cells.

Thanks for any help.