+ Reply to Thread
Results 1 to 3 of 3

Macro to scan rows and columns to replace values with a blank

  1. #1
    Registered User
    Join Date
    01-28-2015
    Location
    Peoria, Illinois
    MS-Off Ver
    2013
    Posts
    23

    Macro to scan rows and columns to replace values with a blank

    In my example spreadsheet I want to scan A4:I28 and replace values above 300 and below -100 with a blank or preferably no value.

    I have the numbers below -100 highlighted in red and the numbers above 300 in green.
    This is a small subset of a much larger number of columns and rows in my sheet.

    Thanks for the assistance!

    -Troy
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    08-28-2014
    Location
    Texas, USA
    MS-Off Ver
    2016
    Posts
    1,796

    Re: Macro to scan rows and columns to replace values with a blank

    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    01-28-2015
    Location
    Peoria, Illinois
    MS-Off Ver
    2013
    Posts
    23

    Re: Macro to scan rows and columns to replace values with a blank

    Thank you kindly! Worked like a charm.

    -Troy

+ 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. Replies: 3
    Last Post: 02-20-2013, 08:54 PM
  2. Replies: 5
    Last Post: 11-12-2012, 08:38 PM
  3. Replies: 2
    Last Post: 02-06-2012, 05:16 PM
  4. insert blank rows based on columns a values numerically
    By elkhole in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-18-2009, 04:57 AM
  5. HOW CAN I SCAN DATA WITH COLUMNS AND ROWS DIRECTLY INTO SPREADSHE.
    By SUFI DARWAISH in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 04-20-2005, 01:06 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