I have a piece of code (vba) that goes through each row and gives it a graph (this works), however, due to the nature of the spreadsheet (Excel) I am working in, there may be as few as 2-5 data points and up to 20. Because of this, I can not simply hard code the columns of data and let the row number change as I previously had it. I have set up a selectcase statement that takes the two defining column factors, subtracts them and gives me how many columns I need that then inputs the correct amount of "A" & Row# & ",B" & Row# etc, into a string, however when I use the ActiveChart.SetSourceData Source:=Range(ColumnAmtStr) statement I get either an error of 448 "Named argument not found" or 1004 "Method 'Range of object '_Global' failed".
Any words of advice?
Bookmarks