in range
 

I have a spreadsheet with a lot of rows 50K, I need to do an action if
column the value in "N" is one of 8 to 14 numbers. Such as

If N.value = 1,2,3,4,5,6,7,14,121,122,123,124,201,202
then do something
else do nothing

There will be 10 of these statements, so maybe a case statement like

case 1,2,3,4,5,6,7,14,121,122,123,124,201,202
do something
case 151,152,153,154,155,156,157,214,215,216
do something


any suggestions?

in range
 

Your case statement is done like this:
Code:
--------------------
SUB USINGCASESTATEMENT()
[/b] SELECT CASE RANGE(\"A1\").VALUE
CASE 100, 150, 200, 350, 400
RANGE(\"B1\").VALUE = RANGE(\"A1\").VALUE
CASE ELSE
RANGE(\"B1\").VALUE = 0
END SELECT
[b]END SUB
--------------------


Striker;256692 Wrote:
I have a spreadsheet with a lot of rows 50K, I need to do an action if
column the value in "N" is one of 8 to 14 numbers. Such as

If N.value = 1,2,3,4,5,6,7,14,121,122,123,124,201,202
then do something
else do nothing

There will be 10 of these statements, so maybe a case statement like

case 1,2,3,4,5,6,7,14,121,122,123,124,201,202
do something
case 151,152,153,154,155,156,157,214,215,216
do something


any suggestions?


--
Simon Lloyd

Regards,
Simon Lloyd
'The Code Cage' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=71653

in range
 

I think you answered the question for yourself. Here is something to play
with

Sub tryme()
For j = 1 To 5
N = InputBox("Give me a number")
Select Case N
Case 1, 2, 3, 4, 5, 6, 7, 14, 121, 122, 123, 124, 201, 202
MsgBox "first group"
Case 10, 20, 30
MsgBox "second group"
Case Else
MsgBox "not found"
End Select
Next j
End Sub

best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"Striker" wrote in message
...
I have a spreadsheet with a lot of rows 50K, I need to do an action if
column the value in "N" is one of 8 to 14 numbers. Such as

If N.value = 1,2,3,4,5,6,7,14,121,122,123,124,201,202
then do something
else do nothing

There will be 10 of these statements, so maybe a case statement like

case 1,2,3,4,5,6,7,14,121,122,123,124,201,202
do something
case 151,152,153,154,155,156,157,214,215,216
do something


any suggestions?