Selecting cells in one column based on criteria in another

[CDandVinyl]

Selecting cells in one column based on criteria in another

Hi All

I need some help with some VBA code please. I'm using Excel 2003.

I need to select the cells in Column L which are below an input number in Column A.

For example , a message box would request an input. I enter 4000. It looks down column A and where the cell value is below 4000 , it selects the equivalent cells by row in column L.

For example

If A1 contains a number less than the input number , then cell L1 is selected. This would loop through all the numbers in A and select equivalent cells in L.


Grateful for any help.


Best Wishes ,

[JOHN H. DAVIS]

Does this help?

Please Login or Register  to view this content.

[CDandVinyl]

hi John

Ok thanks for getting back so quickly. I gave it a go and it gave an error.

See attached.

The debugger highlighted this line :

Range(z).Select

Grateful for your advice.

Best Wishes ,

[JOHN H. DAVIS]

Can you attach the actual file (use dummy data) which causes the error?

[CDandVinyl]

Hi

Yes , of course. It is attached.

Best Wishes ,

[JOHN H. DAVIS]

Um. I can't duplicate the error when I run it?

[CDandVinyl]

Hi John

How strange.

I ran it again on the small sample file I sent before and it didn't give an error , but didn't select any cells either.

I also tried again with my full file and after some hesitation , it gives the error as before.

I'm using 2003 here , maybe that's the issue.

I don't know if there's another way around...

Best Wishes ,

[JOHN H. DAVIS]

If no one else helps out, I will take another look tomorrow. Although I couldn't duplicate the error and I do get results. They results I'm getting does not meet the requirement.

[CDandVinyl]

Hi John

OK thanks for your help. It's appreciated.

Best Wishes ,