So I have a basic Macro to select some data and create a chart - this works perfectly.
The problem I have is that I need to create 78 of these charts.
I am trying to get Excel to update the chart data for each estblishment based on a single reference cell that drive a host of VLOOKUP and INDEX Arguments. When it has created the first chart and heads back to do the next one, it doesn't change the single value reference and keeps creating the same chart oer and over.
I am testing with only 4 references at first but want to rollout to 78 eventually.
The issue is that it keeps creating charts for Interger 2
Help please?
The problem I have is that I need to create 78 of these charts.
I am trying to get Excel to update the chart data for each estblishment based on a single reference cell that drive a host of VLOOKUP and INDEX Arguments. When it has created the first chart and heads back to do the next one, it doesn't change the single value reference and keeps creating the same chart oer and over.
I am testing with only 4 references at first but want to rollout to 78 eventually.
Code:
'Application.ScreenUpdating = False
' This will eventually be 2 to 79
For I = 2 To 5
Range("K" & I).Copy
ActiveSheet.Range("b3").PasteSpecial Paste:=xlPasteValues
'this sub works perfectly
Call createchart
On Error Resume Next
'name of the sheet where I want Excel to loop through the list
ActiveSheet.Range("Chart Data").Activate
Next I
Application.CutCopyMode = False
'Application.ScreenUpdating = True
End Sub
The issue is that it keeps creating charts for Interger 2
Help please?