Find All.... Then Select All

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Given the range A1:A1000, I'm trying to write some code that will look in the
values throughout the range, find all those cells that have the word "Test"
(or other critieria) in them, and then select all of these cells.

I have tried to use the Find function in excel to do this, and while I can
use this function to find all values in a given range, I'm not able to then
immediately select these same values. Thanks for your help.
 
try either data>filter>autofilter
or look in the visual basic editor HELP for find. There is a good example of
findnext
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Need Countifs Formula Help 0
VBA set thick borders around non empty cells in range 0
Delete rows based on contents of Col A 0
Find the correct sheet then find a value on that sheet 8
Ron de Bruin - Merge cells from all worksheets 0
Change Event code 6
Cell values to an array, then array transpose to another workbook 8
[Q] For, Next - How to Speed Up 6

Back
Top