Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: DELETE COLUMN

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I have a sheet with the following macroline:

    With Sheets("XXX").Columns(1)
    .Delete
    End With

    This means that column A is deleted.
    What if I want also to delete column C

    Is it possible in the same macroline?
    Thanks

  2. #2

    Join Date
    Mar 2002
    Posts
    22
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-19 07:56, verluc wrote:
    I have a sheet with the following macroline:

    With Sheets("XXX").Columns(1)
    .Delete
    End With

    This means that column A is deleted.
    What if I want also to delete column C

    Is it possible in the same macroline?
    Thanks

    Sheets("XXX").Range("A:A, C:C").Delete

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    1,451
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-19 08:05, Amds wrote:
    On 2002-04-19 07:56, verluc wrote:
    I have a sheet with the following macroline:

    With Sheets("XXX").Columns(1)
    .Delete
    End With

    This means that column A is deleted.
    What if I want also to delete column C

    Is it possible in the same macroline?
    Thanks

    Sheets("XXX").Range("A:A, C:C").Delete
    Thanks for your solution.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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