Select cells in one column based on input values in another.

[CDandVinyl]

Hi All

I’m trying to select cells in one column based on input values in another. The values are variable and could be input via a series of message boxes.

For example , in the first message box I would perhaps enter column B.

The next message box would ask lower and upper numbers. I might enter 25000 and 35000.

The last message box would ask for input of a second column. I might put column A.

The macro would then select the cells in A where the number is between 25000 and 35000 in column B.

Can someone suggest some code to satisfy this?

Grateful for any help.

[mehmetcik]

Sounds like a lot of hard work. you need 4 Inputs.

Try the attached Workbook instead. Click on the button to get started.

I have not coded for the max number yet. Is it really needed. Let me know.

[Rick Rothstein]

For example , in the first message box I would perhaps enter column B.

What would be in this column... numeric constants or formulas outputting numbers?

[CDandVinyl]

Hi

Thanks for your help guys.

All of the values are numeric constants. There are no formulas involved.

[Rick Rothstein]

See if this macro does what you want...

Please Login or Register  to view this content.

[CDandVinyl]

Excellent. Worked perfectly first time and does the job exactly. Many Thanks!

Problem solved!

[CDandVinyl]

BTW - As I would need to run the code though a few times to cover all of the values in the chosen columns , I added the string and variable names to the message box code so that they would be in place for second and subsequent run-throughs. Just for a little time-saving really.

This worked fine for these examples :

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

In each of these , the variable used in the first run through is successfully in place , but it doesn't work for this one :

Please Login or Register  to view this content.

Is there a way to have the LowUp value input in the first run in place for the second run? It would act as a reminder of the numbers entered in the first run so I can update as need be for the next run.

I'm grateful again for your help.