Method Range of Object Global Failed

[SBF12345]

I am receiving a "method range of object global failed" error on the line below

.Top = Range(Cells(((aa - 4) * 5), 1))

Set chrt = sh.ChartObjects.Add
 With chrt
.Top = Range(Cells(((aa - 4) * 5), 1))

aa is a for variable. My goal is to stack charts below one another 5 cells apart. The counter starts at the integer 5. How can I define the range with the variable?

 

[Joe4]

Try:

.Top = Cells(((aa - 4) * 5), 1)

or

.Top = Range("A" & (aa - 4) * 5)

If that does not work, confirm what the value of aa is at the time of error.

 

[SBF12345]

Thanks! that works...I adjusted it for chartobjects

.Top = Range("A" & (aa - 4) * 200)

 

[Joe4]

You are welcome.