Results 1 to 20 of 20

Moving down a chart when inserting rows

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2009
    Location
    Methylane
    MS-Off Ver
    Excel 2003
    Posts
    23

    Moving down a chart when inserting rows

    I've been inserting some rows in some sheets and everything is sound... Until I meet a chart! Charts in general are terrain I yet have to explore (and will be coming Monday)...

    I insert a row like this:
    .Range(.Cells(y, x), .Cells(y, x)).Copy
    .Range(.Cells(y, x), .Cells(y, x)).Insert Shift:=xlDown, CopyOrigin:=True
    Works like a charm, it keeps formatting and the dreaded merged cells where I need to keep them, but! Say it inserts 20 rows, but it encounters a chart, the rows keep getting inserted, but the chart isn't moved down accordingly!
    Last edited by ctor; 11-09-2009 at 09:11 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1