C
cesaoes
this is my line
ActiveChart.SetSourceData Source:=Sheets("Sheet9").Range("A5")
and i keep getting an error becuase, Sheets9 will stay like that, but every
time i run my macro, the sheet number where this is saved will be increasing
the next one will be
sheet10
sheet11....
how do i make it so it understand that has to run the latest one?
ActiveChart.SetSourceData Source:=Sheets("Sheet9").Range("A5")
and i keep getting an error becuase, Sheets9 will stay like that, but every
time i run my macro, the sheet number where this is saved will be increasing
the next one will be
sheet10
sheet11....
how do i make it so it understand that has to run the latest one?