heisenber2342
09-03-2018 11:13:27
bom dia.
Encontrei no fórum alguns textos relacionados a este problema. no excel, porém não conseguir utilizar no meu caso, alguém poderia me ajudar? Sou totalmente novo em VBA e estou com problemas neste caso.
Fiz um gráfico com botões referente aos meses do ano. toda vez que eu clico no botão do mês de fevereiro o gráfico atualizada com os dados da tabela de fevereiro e assim acontece com os outros meses, o problema é que quando eu salvo o arquivo e abro novamente aparece o erro
Erro tempo de execução '91':
A variável do objeto ou a variável do bloco 'With' não foi definida
Segue as linhas que dão problema em janeiro (a linha que aparece a falha é ActiveChart.SetSourceData Source:=Range("A309:B329"))
fevereiro está linha aparece ActiveChart.Axes(xlValue).MajorGridlines.Select
os outros meses a linha que dá problema é ActiveChart.SetSourceData Source:=Range
Sub JANVENDA()
'
' JANVENDA Macro
'
'
ActiveWindow.SmallScroll Down:=9
ActiveChart.SetSourceData Source:=Range("A309:B329")
ActiveWindow.SmallScroll Down:=-24
ActiveWindow.ScrollColumn = 2
End Sub
Sub FEVVENDA()
'
' FEVVENDA Macro
'
'
ActiveChart.Axes(xlValue).MajorGridlines.Select
ActiveChart.SetSourceData Source:=Range("D309:E329")
ActiveWindow.SmallScroll Down:=-21
End Sub
Sub MARVENDA()
'
' MARVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("G309:H329")
ActiveWindow.SmallScroll Down:=-21
End Sub
Sub ABRVENDA()
'
' ABRVENDA Macro
'
'
ActiveChart.Axes(xlValue).MinorGridlines.Select
ActiveChart.SetSourceData Source:=Range("J309:K329")
ActiveWindow.SmallScroll Down:=-21
End Sub
Sub MAIVENDA()
'
' MAIVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("M309:N329")
ActiveWindow.SmallScroll Down:=-21
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollColumn = 2
ActiveWindow.SmallScroll Down:=-3
End Sub
Sub JUNVENDA()
'
' JUNVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("P309:Q329")
ActiveWindow.SmallScroll Down:=-21
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.SmallScroll Down:=-3
End Sub
Sub JULVENDA()
'
' JULVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("S309:T329")
ActiveWindow.SmallScroll Down:=-21
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.SmallScroll Down:=-3
End Sub
Sub AGOVENDA()
'
' AGOVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("V309:W329")
ActiveWindow.SmallScroll Down:=-24
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 8
ActiveWindow.ScrollColumn = 7
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollColumn = 2
End Sub
Sub SETVENDA()
'
' SETVENDA Macro
'
'
ActiveChart.Axes(xlValue).MajorGridlines.Select
ActiveChart.SetSourceData Source:=Range("Y309:Z329")
ActiveWindow.SmallScroll Down:=-21
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 8
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
End Sub
Sub OUTVENDA()
'
' OUTVENDA Macro
'
'
ActiveWindow.SmallScroll Down:=6
ActiveChart.Axes(xlValue).MinorGridlines.Select
ActiveChart.SetSourceData Source:=Range("AB309:AC329")
ActiveWindow.SmallScroll Down:=-24
ActiveWindow.ScrollColumn = 10
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollColumn = 2
End Sub
Sub NOVVENDA()
'
' NOVVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("AE309:AF329")
ActiveWindow.SmallScroll Down:=-36
ActiveWindow.ScrollColumn = 11
ActiveWindow.ScrollColumn = 10
ActiveWindow.ScrollColumn = 8
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollColumn = 2
ActiveWindow.SmallScroll Down:=9
End Sub
Sub DEZVENDA()
'
' DEZVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("AH309:AI329")
ActiveWindow.ScrollColumn = 13
ActiveWindow.ScrollColumn = 12
ActiveWindow.ScrollColumn = 11
ActiveWindow.ScrollColumn = 7
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 1
ActiveWindow.SmallScroll Down:=-27
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
End Sub
Quem puder me ajudar ficaria grato.
Encontrei no fórum alguns textos relacionados a este problema. no excel, porém não conseguir utilizar no meu caso, alguém poderia me ajudar? Sou totalmente novo em VBA e estou com problemas neste caso.
Fiz um gráfico com botões referente aos meses do ano. toda vez que eu clico no botão do mês de fevereiro o gráfico atualizada com os dados da tabela de fevereiro e assim acontece com os outros meses, o problema é que quando eu salvo o arquivo e abro novamente aparece o erro
Erro tempo de execução '91':
A variável do objeto ou a variável do bloco 'With' não foi definida
Segue as linhas que dão problema em janeiro (a linha que aparece a falha é ActiveChart.SetSourceData Source:=Range("A309:B329"))
fevereiro está linha aparece ActiveChart.Axes(xlValue).MajorGridlines.Select
os outros meses a linha que dá problema é ActiveChart.SetSourceData Source:=Range
Sub JANVENDA()
'
' JANVENDA Macro
'
'
ActiveWindow.SmallScroll Down:=9
ActiveChart.SetSourceData Source:=Range("A309:B329")
ActiveWindow.SmallScroll Down:=-24
ActiveWindow.ScrollColumn = 2
End Sub
Sub FEVVENDA()
'
' FEVVENDA Macro
'
'
ActiveChart.Axes(xlValue).MajorGridlines.Select
ActiveChart.SetSourceData Source:=Range("D309:E329")
ActiveWindow.SmallScroll Down:=-21
End Sub
Sub MARVENDA()
'
' MARVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("G309:H329")
ActiveWindow.SmallScroll Down:=-21
End Sub
Sub ABRVENDA()
'
' ABRVENDA Macro
'
'
ActiveChart.Axes(xlValue).MinorGridlines.Select
ActiveChart.SetSourceData Source:=Range("J309:K329")
ActiveWindow.SmallScroll Down:=-21
End Sub
Sub MAIVENDA()
'
' MAIVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("M309:N329")
ActiveWindow.SmallScroll Down:=-21
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollColumn = 2
ActiveWindow.SmallScroll Down:=-3
End Sub
Sub JUNVENDA()
'
' JUNVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("P309:Q329")
ActiveWindow.SmallScroll Down:=-21
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
ActiveWindow.SmallScroll Down:=-3
End Sub
Sub JULVENDA()
'
' JULVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("S309:T329")
ActiveWindow.SmallScroll Down:=-21
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.SmallScroll Down:=-3
End Sub
Sub AGOVENDA()
'
' AGOVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("V309:W329")
ActiveWindow.SmallScroll Down:=-24
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 8
ActiveWindow.ScrollColumn = 7
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollColumn = 2
End Sub
Sub SETVENDA()
'
' SETVENDA Macro
'
'
ActiveChart.Axes(xlValue).MajorGridlines.Select
ActiveChart.SetSourceData Source:=Range("Y309:Z329")
ActiveWindow.SmallScroll Down:=-21
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 8
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 3
End Sub
Sub OUTVENDA()
'
' OUTVENDA Macro
'
'
ActiveWindow.SmallScroll Down:=6
ActiveChart.Axes(xlValue).MinorGridlines.Select
ActiveChart.SetSourceData Source:=Range("AB309:AC329")
ActiveWindow.SmallScroll Down:=-24
ActiveWindow.ScrollColumn = 10
ActiveWindow.ScrollColumn = 9
ActiveWindow.ScrollColumn = 6
ActiveWindow.ScrollColumn = 4
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollColumn = 2
End Sub
Sub NOVVENDA()
'
' NOVVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("AE309:AF329")
ActiveWindow.SmallScroll Down:=-36
ActiveWindow.ScrollColumn = 11
ActiveWindow.ScrollColumn = 10
ActiveWindow.ScrollColumn = 8
ActiveWindow.ScrollColumn = 5
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 1
ActiveWindow.ScrollColumn = 2
ActiveWindow.SmallScroll Down:=9
End Sub
Sub DEZVENDA()
'
' DEZVENDA Macro
'
'
ActiveChart.SetSourceData Source:=Range("AH309:AI329")
ActiveWindow.ScrollColumn = 13
ActiveWindow.ScrollColumn = 12
ActiveWindow.ScrollColumn = 11
ActiveWindow.ScrollColumn = 7
ActiveWindow.ScrollColumn = 3
ActiveWindow.ScrollColumn = 1
ActiveWindow.SmallScroll Down:=-27
ActiveWindow.ScrollColumn = 2
ActiveWindow.ScrollColumn = 3
End Sub
Quem puder me ajudar ficaria grato.