Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
variable code
Would appreciate help with what I am doing wrong.. vba
does not like the lines containing the variables for setting chart parameters: Sub last1500() Dim currentrow As Integer Dim beginrow As Integer currentrow = Worksheets("data").Range("aa1").Value beginrow = currentrow - 1500 Application.ScreenUpdating = False ActiveSheet.ChartObjects("Chart 10").Activate ActiveChart.SeriesCollection(1).Values = "=DATA! RbeginrowC5:RcurrentrowC5" ActiveChart.SeriesCollection(2).Values = "=DATA! RbeginrowC19:RcurrentrowC19" End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
can i link a variable cost code with a variable sum | Excel Discussion (Misc queries) | |||
VBA Code - NAME SEVERAL VARIABLE cells | Excel Worksheet Functions | |||
variable code?? | Excel Discussion (Misc queries) | |||
How to use a variable as a sheets code name | Excel Programming | |||
Variable in a VB Code | Excel Programming |