If You Need Information On Range Case Then This is The Best Untapped Resource On The Web
 |
 Aluminum Range Hood Filter 8 1 4 X 11 1 4 X 3 8  US $10.88
|
 36 KITCHEN WALL RANGE HOOD STAINLESS BAFFLE FABIA 36 B US $329.00
|
 30 STAINLESS w BAFFLE filter WALL RANGE HOOD BREA 30 B US $335.00
|
 36 Kitchen WALL RANGE HOOD STAINLESS BAFFLE ELISA 36 B US $329.00
|
 MARVEL 6BARBBG 24 BEVERAGE CENTER 14 BOTTLE CAPACITY US $999.00
|
 30 WIDTH WALL MOUNTED STAINLESS STEEL RANGE HOOD FAN US $299.99
|
 Kenmore Range Burner Switch 89 110A WB23M0024 US $12.99
|
 Kenmore Range Burner Switch 54 70A WB23M0024 US $12.99
|
 Kenmore Range Clock WB11X0008 3AMT5E121A1B US $55.99
|
how do i select case several rows on excel VBA?
"Select Case Range("A").Value
Case 10247700, 10431454, 10465916, 11794934"
instead of looking for these values that are hard coded. I want it to do
Case range(E5:E20)
something like that. but none of my code is working!! I have to do array or something? But how?
You could do it sort of 'back door' like this. This example macro will display a message box with the cell address in range E5:E20 that matches the value in A1. You could replace the message box with your actual code to process.
Sub Special_SelectCase()
For Each cell In Range("E5:E20")
Select Case cell.Value
Case Is = Range("A1").Value
MsgBox cell.Address
End Select
Next
End Sub
Eagle Industries Discreet Case Review