I have VBA code automatically creating 3 charts on a sheet, but the number of data series for each chart can vary which effects the size of the charts. So I need to be able to place a chart on Page 2 depending on the number of data series the charts have.
How do I specifify in VBA to go to (select) the cell that is the top of page 2 in the active worksheet? My code to position the chart looks like this at the moment:
With ThisChart
With .Parent
.Top = Range("A2").Top
.Left = Range("A2").Left
.Name = "IEPChart"
.Width = 500
.Height = 200
End With
End With
When needed, I'd like to be able to specify the range to be the first cell in column A of Page 2 of the active worksheet. Any suggestions on code that would do this? Thanks!
How do I specifify in VBA to go to (select) the cell that is the top of page 2 in the active worksheet? My code to position the chart looks like this at the moment:
With ThisChart
With .Parent
.Top = Range("A2").Top
.Left = Range("A2").Left
.Name = "IEPChart"
.Width = 500
.Height = 200
End With
End With
When needed, I'd like to be able to specify the range to be the first cell in column A of Page 2 of the active worksheet. Any suggestions on code that would do this? Thanks!