Thread: Find problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Francis Hookham Francis Hookham is offline
external usenet poster
 
Posts: 125
Default Find problem

Column 1 contains the numeric ID of about 2,000 rows.

A variable iID, or should it be sID, records the ID before sorting by
another column.

I then need to find which particular row contains the ID, select it and
scroll to it.



The problem:

Let us say the ID is 27

After sorting 27 is below 275 so 'Find' finds 275 first!



How can I find the row which contains the ID 27 and not a larger number
containing the original digits?



Francis Hookham