Search In Columns & Select Rows

Posted by David H on January 05, 2002 9:13 AM

Hi,

I have an Excel spreadsheet with approx 14 columns and 500 rows of data.

I am trying to create the following -

1) User prompt so user selects which column they want to search

2) User prompt so they can enter the start number to search for

3) User prompt so they can enter the stop number to search for

4) For the Macro to look through the data and wherever the data is found the row which it is held within it also selected.

So, for example, entering 1 and 5 will search for numbers 1,2,3,4,5. I could hard-code it but want the flexibility of the user deciding the search criteria.

Any ideas?! Please...?

Posted by denis on January 06, 2002 5:50 AM

create a userform with textbox's to enter the row's, column's & the number's to be found from and to.

It won't be that hard to create. email me if you have a promblem.