ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do Incorporate a condition in a case statement? (https://www.excelbanter.com/excel-programming/422302-how-do-incorporate-condition-case-statement.html)

Jay

How do Incorporate a condition in a case statement?
 
Is it possible for me to combine the Case statement with the following
conditions.
I already tried this but I'm having an error with it.

e.g.
Case rw = rwBon And rw <= rwBonx

if possible please can I have an example, coz i think its possible but it
dunno how.

Thanks.
Jay



joel

How do Incorporate a condition in a case statement?
 
:Select Case Rw

Case rwbon To rwBonx:

End Select


"Jay" wrote:

Is it possible for me to combine the Case statement with the following
conditions.
I already tried this but I'm having an error with it.

e.g.
Case rw = rwBon And rw <= rwBonx

if possible please can I have an example, coz i think its possible but it
dunno how.

Thanks.
Jay




All times are GMT +1. The time now is 10:51 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com