Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup horizontal...
Have this range D2:CE2 filled with a many value and a My_var filled
with a value I want to find in this range if value of My_var existis in range D2:CE2... if existis goto other code1 else goto other code2 how to in VBA? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup horizontal...
Hi,
Right click your sheet, view code and paste this in Sub nn() my_var = 99 Set myrange = Range("D2:CE2") On Error Resume Next For Each c In myrange If c.Value = my_var Then 'run code1 Else 'run code2 End If Next End Sub You must consider what you do after you have run code1 or code2 because execution will return back into this routine. You could do this If c.Value = my_var Then 'run code1 exit sub Else 'run code2 exit sub End If Mike "sal21" wrote: Have this range D2:CE2 filled with a many value and a My_var filled with a value I want to find in this range if value of My_var existis in range D2:CE2... if existis goto other code1 else goto other code2 how to in VBA? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup horizontal...
Ignore my last post I had an elderly moment, try this instead
Sub nn() my_var = 999 Set myrange = Range("D2:CE2") On Error Resume Next For Each c In myrange If c.Value = my_var Then code1 Exit Sub End If Next code2 End Sub Sub code1() MsgBox 1 End Sub Sub code2() MsgBox 2 End Sub "Mike H" wrote: Hi, Right click your sheet, view code and paste this in Sub nn() my_var = 99 Set myrange = Range("D2:CE2") On Error Resume Next For Each c In myrange If c.Value = my_var Then 'run code1 Else 'run code2 End If Next End Sub You must consider what you do after you have run code1 or code2 because execution will return back into this routine. You could do this If c.Value = my_var Then 'run code1 exit sub Else 'run code2 exit sub End If Mike "sal21" wrote: Have this range D2:CE2 filled with a many value and a My_var filled with a value I want to find in this range if value of My_var existis in range D2:CE2... if existis goto other code1 else goto other code2 how to in VBA? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
lookup horizontal...
On 14 Apr, 14:46, Mike H wrote:
Ignore my last post I had an elderly moment, try this instead Sub nn() my_var = 999 Set myrange = Range("D2:CE2") On Error Resume Next For Each c In myrange * * If c.Value = my_var Then * * * * code1 * * * * Exit Sub * * End If Next code2 End Sub Sub code1() * * * * *MsgBox 1 End Sub Sub code2() * * * MsgBox 2 End Sub "Mike H" wrote: Hi, Right click your sheet, view code and paste this in Sub nn() my_var = 99 Set myrange = Range("D2:CE2") On Error Resume Next For Each c In myrange If c.Value = my_var Then * * * * 'run code1 * * Else * * * * * *'run code2 * * End If Next End Sub You must consider what you do after you have run code1 or code2 because execution will return back into this routine. You could do this If c.Value = my_var Then * * * * 'run code1 * * * * *exit sub * * Else * * * * * *'run code2 * * * * * *exit sub * * End If Mike "sal21" wrote: Have this range D2:CE2 filled with a many value and a My_var filled with a value I want to find in this range if value of My_var existis in range D2:CE2... if existis goto other code1 else goto other code2 how to in VBA?- Nascondi testo tra virgolette - - Mostra testo tra virgolette - Excellent code! Tks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need lookup of data both vertical and horizontal | Excel Discussion (Misc queries) | |||
how do i set up a horizontal spreadsheet? | Excel Worksheet Functions | |||
Horizontal Filtering | Excel Discussion (Misc queries) | |||
Sumproduct and horizontal lookup | Excel Discussion (Misc queries) | |||
Horizontal split | New Users to Excel |