Select data
Use Data=Filter=Autofilter
in the dropdown for that column, select the Custom under the choices and
then set up this with greater than or equal to and less than or equal to.
Type your values in the boxes.
If you want code, turn on the macro recorder while you do it manually.
If you meant throughout that matrix I suspect you would need to loop through
it making a comparison for each cell. Then the question would be what to
you mean by select. You could accumulate the cells meeting the test using
the union function.
--
Regards,
Tom Ogilvy
"dr" wrote in message
...
How can I select data within defined limits. For example select all data
between 0.002027 and 0.00228 in a 49x38 matrix?
Thanks
|