+ Reply to Thread
Results 1 to 2 of 2

Delete Range based on Varied Cell

  1. #1
    Registered User
    Join Date
    09-08-2018
    Location
    Prescott, WI
    MS-Off Ver
    365
    Posts
    36

    Unhappy Delete Range based on Varied Cell

    Next Question

    How can I automate the Deletion of cell values that starts with a random cell?

    Right now I do
    1. "FIND" for "Pay Code for All" (located in the A Column)
    2. Move up 2 Cells (this is where the Range starts)
    3. Selected Final Range Cell E600
    4. Delete Selection


    Thank you in Advance!!
    Attached Files Attached Files
    Last edited by Bryan.Pagenkopf; 07-11-2019 at 08:29 AM.

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,446

    Re: Delete Range based on Varied Cell

    Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

+ 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. [SOLVED] Macro To Completely Delete Contents Of A Cell Range Based On Specific Text In The Cell
    By Learner_Mike in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-01-2019, 03:49 PM
  2. VB to delete range in rows based on value of cell
    By MacroNovice18 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-20-2019, 02:25 PM
  3. [SOLVED] Delete rows in defined range based on cell value
    By Villalobos in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-19-2016, 01:23 PM
  4. Hiding varied columns based on the value of one cell
    By drewfy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-21-2015, 10:02 AM
  5. Delete Range based on cell value with variable row - Should be simple
    By RichTea88 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-19-2014, 06:34 AM
  6. [SOLVED] Delete range of cells based on a cell value (Date).
    By pipoliveira in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-06-2013, 05:21 AM
  7. excel 2010 question regarding =min/=max with varied range
    By supernova805 in forum Excel General
    Replies: 2
    Last Post: 04-11-2012, 09:17 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