Results 1 to 2 of 2

Thread: Delete unwanted rows & column

  1. 09-30-2012, 12:33 AM #1
    sanjeevi888
    sanjeevi888 is offline
    Junior Member
    Join Date
    Jun 2012
    Posts
    15
    Rep Power
    0

    Delete unwanted rows & column

    hi.. I want excel diet to Row U & column 2000
    as soon as posible
    Reply With Quote Reply With Quote
  2. 09-30-2012, 08:52 AM #2
    Admin
    Admin is offline
    Administrator Admin's Avatar
    Join Date
    Mar 2011
    Posts
    1,122
    Rep Power
    10
    What do you mean by unwanted ?

    to delete everything after Column U and Row 2000, try this.

    Code:
    Range(Cells(1, "v"), Cells(1, Columns.Count)).EntireColumn.Delete
Range(Cells(2001, 1), Cells(Rows.Count, 1)).EntireRow.Delete
    Cheers !

    Excel Range to BBCode Table
    Use Social Networking Tools If You Like the Answers !

    Message to Cross Posters

    @ Home - Office 2010/2013/2016 on Win 10 (64 bit); @ Work - Office 2016 on Win 10 (64 bit)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Similar Threads

  1. Delete Rows Based on Conditions
    By AbiG2009 in forum Excel Help
    Replies: 6
    Last Post: 12-26-2018, 01:24 PM
  2. Delete Remove Rows By Criteria VBA Excel
    By marreco in forum Excel Help
    Replies: 5
    Last Post: 12-20-2012, 05:56 PM
  3. Delete Rows
    By ayazgreat in forum Excel Help
    Replies: 2
    Last Post: 12-13-2012, 11:48 AM
  4. Selecting/deselecting rows - then sort & Hide/Unhide rows
    By Rasm in forum Download Center
    Replies: 2
    Last Post: 05-06-2011, 02:59 AM
  5. Delete Empty Rows
    By Rasm in forum Excel Help
    Replies: 4
    Last Post: 04-28-2011, 02:13 AM

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
  •  

Forum Rules