JKB
10-12-2015, 12:54 AM
Hi!
I have this code:
'ActiveChart.SetSourceData Source:=shtHis.Range("A1:A1238,D1:D1238")
I would like the "1238" not to refer to a cell instead, is this possible? it's important that the two columns are "seperate" i.e. that column a, b, c and d aren't selected but only column a and d?
The cell value could fx be "100" and then the graph data would only display the shtHis.Range("A1:A100,D1:D100")
Can anybody help me with this?
Cheers
I have this code:
'ActiveChart.SetSourceData Source:=shtHis.Range("A1:A1238,D1:D1238")
I would like the "1238" not to refer to a cell instead, is this possible? it's important that the two columns are "seperate" i.e. that column a, b, c and d aren't selected but only column a and d?
The cell value could fx be "100" and then the graph data would only display the shtHis.Range("A1:A100,D1:D100")
Can anybody help me with this?
Cheers