Hello All,
I have 4 charts all created via code. They are all placed like via:
With ActiveChart.Parent
.Top = Range("N103").Top
.Left = Range("N103").Left
End With
And I am using this to keep them from moving around:
With ActiveChart.Parent
.Placement = xlFreeFloating
End With
I then added a small amount of code to bring in some tables. They put outside of the columns that have the data and charts. When the tables are added all of the Charts move up. I have tried:
.RefreshStyle = xlInsertDeleteCells
.RefreshStyle = xlOverwriteCells
.RefreshStyle = xlInsertEntireRows
and they all still move the charts. The charts move 21 rows up, the new data, way over in column S (again outside the chart and data area) is about 41 rows.
Anyone have an idea how I can stop the charts from moving?
Thanks,
David
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar