+ Reply to Thread
Results 1 to 4 of 4

VBA Commad for deleting the rows

  1. #1
    Registered User
    Join Date
    09-23-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    56

    VBA Commad for deleting the rows

    Dear Sir,

    I need an VBA command to delete the rows of containing the values of PK & Blank, from the column H.

    Kinldy help me in this, I have attched the raw data for your reference.

    Regards,
    Mohan
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: VBA Commad for deleting the rows

    hi mohan_rajun, please check attachment, press "Clear data" button
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    09-23-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    56

    Re: VBA Commad for deleting the rows

    I need a VBA command..pls help me out..

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,445

    Re: VBA Commad for deleting the rows

    watersev has provided just such an example (see below) ... demonstrated in the attachment.

    Does this not work for you?

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ 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