Find All.... Then Select All
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. |
Find All.... Then Select All
try either datafilterautofilter
or look in the visual basic editor HELP for find. There is a good example of findnext -- Don Guillett SalesAid Software "Jason" wrote in message ... 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. |
All times are GMT +1. The time now is 10:09 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com