+ Reply to Thread
Results 1 to 8 of 8

Selective delete using VBA

  1. 09-20-2010, 06:40 AM #1
    ckattookaran is offline
    Registered User
    Join Date
    04-09-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Selective delete using VBA

    Hi All

    I've a requirement in which i've to delete 2,3,4 rows...and then 8,9,10 then 14,15,16.....rows....

    But when i try to do this....using record macro...i'm not able to perform the same.

    Can someone please help me
    Reply With QuoteRegister To Reply
  2. 09-20-2010, 06:58 AM #2
    Richard Buttrey is offline
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Selective delete using VBA

    Hi,

    If you are referring to specific row numbers then

    Please Login or Register  to view this content.
    HTH
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.
    Reply With QuoteRegister To Reply
  3. 09-20-2010, 07:21 AM #3
    ckattookaran is offline
    Registered User
    Join Date
    04-09-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Selective delete using VBA

    Hi Richard

    It's not specific...but the order is like that..... 2to4, 8 to 10....but it can continue till 200 rows....
    Last edited by shg; 09-20-2010 at 07:21 AM. Reason: deleted quote
    Reply With QuoteRegister To Reply
  4. 09-20-2010, 07:22 AM #4
    shg is offline
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: Selective delete using VBA

    ckattookaran, please doen't quote whole posts; it's just clutter. Use the REPLY button, not the QUOTE button.

    Thanks.
    Entia non sunt multiplicanda sine necessitate
    Reply With QuoteRegister To Reply
  5. 09-20-2010, 07:29 AM #5
    snb is offline
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Selective delete using VBA

    Delete rows from 'bottom' to 'top'

    Please Login or Register  to view this content.

    Reply With QuoteRegister To Reply
  6. 09-20-2010, 07:39 AM #6
    ckattookaran is offline
    Registered User
    Join Date
    04-09-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Selective delete using VBA

    hi smb

    Propably i'll load the excel....I've two tabs in the excel...

    1. Original
    2. Required

    I'm trying to delete the blank lines...
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  7. 09-20-2010, 07:51 AM #7
    snb is offline
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,649

    Re: Selective delete using VBA

    To delete blank lines:

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  8. 09-20-2010, 08:03 AM #8
    ckattookaran is offline
    Registered User
    Join Date
    04-09-2010
    Location
    India
    MS-Off Ver
    Excel 2003
    Posts
    14

    Re: Selective delete using VBA

    Thank you very much smb
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1