+ Reply to Thread
Results 1 to 2 of 2

simple column delete, overlapping sections error?

Hybrid View

  1. #1
    Registered User
    Join Date
    05-24-2012
    Location
    atlanta
    MS-Off Ver
    Excel 2010
    Posts
    45

    simple column delete, overlapping sections error?

    Sheets("Raw Cost Data").Select
    '   This is the list of columns that are to be removed.  If source file changes, update this list.
        '
        Range("A:A,D:D,E:E,G:G,I:I").Select
        '
           Range("I1").Activate
        Selection.Delete Shift:=xlToLeft
    Simple... It deletes the columns listed in the range...

    I even used the record macro to double check and it spits out the same error...

    There are merged cells, but none are the left most cell, none with any values, doing it manually causes no errors or warnings at all.

  2. #2
    Registered User
    Join Date
    05-24-2012
    Location
    atlanta
    MS-Off Ver
    Excel 2010
    Posts
    45

    Re: simple column delete, overlapping sections error?

    I just went at it from a different direction, copying the columns I want instead of deleting those I dont. works... but Im curious if anyone knows what the issue was.

+ Reply to Thread

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