Hi
This is probably a very simple answer, but beyond my very limited knowledge of VBA/macros
I recorded the macro below to show this stage in its simplest form. This is what it records if I perform the range selection manually. However I want to replace this manual range selection with a pop up to select the data during part of a larger macro.
Many thanks in advance for any light that you can shed on this.
Kind regards
Code
Sub Under_80_Votes()
'
' Under_80_Votes
' Transfer of data to charts
'
'
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.PlotArea.Select
ActiveChart.FullSeriesCollection(1).Values = "='<80% Votes'!$P$18:$P$23"
ActiveChart.FullSeriesCollection(2).Values = "='<80% Votes'!$Q$18:$Q$23"
ActiveChart.FullSeriesCollection(2).XValues = "='<80% Votes'!$O$18:$O$23"
End Sub
Display More