Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro calling another macro + variables
I am trying to call another macro plot within a main macro that chooses data.
I define a range "plotvalues" in the main macro and the second macro plots "plotvalues." However, the variable is not being recognized. here is the gist of what my code is like. Sub datasplit() .... plotvalues = ActiveSheet.Range("A1:L15").Address Macroplot End Sub() Sub Macroplot() Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=Sheets("Input").Range(plotvalues), PlotBy:= _ xlColumns End Sub() Please help! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro calling another macro + variables
Dim plotvalues As Range
Sub datasplit() Set plotvalues = ActiveSheet.Range("A1:L15") Macroplot End Sub Sub Macroplot() Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=plotvalues, _ PlotBy:=xlColumns End Sub OR Dim plotvalues As String Sub datasplit() plotvalues = ActiveSheet.Range("A1:L15").Address Macroplot End Sub Sub Macroplot() Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=Sheets("Input").Range(plotvalues), _ PlotBy:=xlColumns End Sub HTH, Bernie MS Excel MVP "yo" wrote in message ... I am trying to call another macro plot within a main macro that chooses data. I define a range "plotvalues" in the main macro and the second macro plots "plotvalues." However, the variable is not being recognized. here is the gist of what my code is like. Sub datasplit() .... plotvalues = ActiveSheet.Range("A1:L15").Address Macroplot End Sub() Sub Macroplot() Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=Sheets("Input").Range(plotvalues), PlotBy:= _ xlColumns End Sub() Please help! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
macro calling another macro + variables
Yo,
You need to pass the variable to the next Sub. Try this... Sub datasplit() plotvalues = ActiveSheet.Range("A1:L15").Address Call Macroplot(plotvalues) 'add the variable name here in () End Sub Sub Macroplot(plotvalues) 'add the variable name here in () 'keep the rest of your code as it is. End Sub Hope that helps! Mark "yo" wrote: I am trying to call another macro plot within a main macro that chooses data. I define a range "plotvalues" in the main macro and the second macro plots "plotvalues." However, the variable is not being recognized. here is the gist of what my code is like. Sub datasplit() .... plotvalues = ActiveSheet.Range("A1:L15").Address Macroplot End Sub() Sub Macroplot() Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SetSourceData Source:=Sheets("Input").Range(plotvalues), PlotBy:= _ xlColumns End Sub() Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro Calling Visual Basic References | Excel Discussion (Misc queries) | |||
macro with F9 | Excel Discussion (Misc queries) | |||
Make Alignment options under format cells available as shortcut | Excel Discussion (Misc queries) | |||
Playing a macro from another workbook | Excel Discussion (Misc queries) | |||
Macro and If Statement | Excel Discussion (Misc queries) |