+ Reply to Thread
Results 1 to 2 of 2

VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)

  1. #1
    Forum Contributor
    Join Date
    09-20-2014
    Location
    India
    MS-Off Ver
    2013
    Posts
    275

    Thumbs up VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)

    Dear all,

    I am facing an problem in deleting the range.

    I have Columns A:D. I have filtered Column D with a Value and deleting cell under Column C:D.

    I want to delete the values under column C:D and move the cells up after deletion.

    But when i delete this filtered range using VBA code Selection.Delete Shift:=xlUp, it deletes all the values under column A:D and then moves it up.

    Is there any way to retain the values under A:B column and delete the values under C:D and move them up.?

    Please note: Data is filtered and then deleted.

    Thanks for any help.

  2. #2
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: VBA code to delete the FILTERED range and moving the cell up (dont Delete entire row)

    Can you share your code with us?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro code to delete entire row if cell in column A is equal to a value
    By mm671750 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-07-2014, 02:54 PM
  2. How to delete entire row if first cell of it is empty for specific range and worksheets
    By roshanvmech in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2014, 12:36 PM
  3. [SOLVED] Delete cell only with certain critria. Don't want to delete entire row, the celsl only
    By RobertOHare in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2013, 04:18 AM
  4. Macro code to delete entire row if the cell in column C = 0
    By glock9mm in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-18-2013, 02:50 PM
  5. find <> empty cell in range, delete entire row
    By Shell_ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-26-2011, 12:36 PM

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