Select/Case question

[hallingh]

Hi all. I'm going to start putting together a sub using select/case today, but I have a question on it. Can you select a range bigger than one cell and then have the cases be specific to certain cells within that range? For example:

Select Case Range("A1:B4")
Case B4.value <> ""
Do This
 
Case B3.value <>""
Do This
 
etc.

I'm not really sure if this is written correctly or if you can even accomplish this using select/case. Any help or insight would be greatly appreciated. Thanks for the looks!

Hank

 

[Joe4]

You only want to select a single value in your Select/Case statements. So if you want to loop through a range a cells, create a loop outside of the Select/Case statements to loop through them.

 

[hallingh]

Thanks for the response. Is there a limit to the number of cases you can use in a select/case?

 

[Joe4]

Not that I know of. At least I have never hit it.

 

[hallingh]

OK. I am going to try and put something together today. If I can't get it to work I'll post my attempt tomorrow at some point. Thanks again for the help.

Hank