Macro to scan rows and columns to replace values with a blank - Followup question

**Vanth_2013** · 03-02-2015, 12:44 PM

My followup question is:

I would like to manually select a range of cells and then click the macro to search the values of each Selected cell, then replace values below -100 or above 300 with "" or no value.

Thanks!

-Troy

**mikeTRON** · 03-02-2015, 01:02 PM

The following should do the trick

Please Login or Register  to view this content.

**Vanth_2013** · 03-02-2015, 02:00 PM

Works perfectly MikeTRON! This will be quite helpful in the future as well.

Thanks! I like your coding.

-Troy

**mikeTRON** · 03-02-2015, 02:59 PM

Great, I made sure to comment everything for you so it is easy for you to audit and/or change in the future.

Macro to scan rows and columns to replace values with a blank - Followup question

LinkBack

Thread Tools

Rate This Thread

Display

Macro to scan rows and columns to replace values with a blank - Followup question

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

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

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

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Macro to scan rows and columns to replace values with a blank

Scan rows for duplicate column values, then add rows together and delete unused rows.

[SOLVED] Bob Phillips followup question on text macro

HOW CAN I SCAN DATA WITH COLUMNS AND ROWS DIRECTLY INTO SPREADSHE.

Followup question for Tom

Bookmarks

Bookmarks

Posting Permissions