| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change Code from a Worksheet
Hi
I have the code If Cells(NB, 5).Value = "WALK" or Cells(NB, 5).Value = "BIKE" or Cells(NB, 5) .Value = "BUS" Then I would like to have WALK BIKE BUS ....... and editions in Sheet A Col A so my code line would be something like If Cells(NB, 5).Value = " Value in cells Sheet A Col A " Then Thanks in advance for any help -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200608/1 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Code from a Worksheet
If not iserror(Application.Match(Cells(NB,
5).Value,worksheets("sheetA").columns(1),0)) Then -- Regards, Tom Ogilvy "FIRSTROUNDKO via OfficeKB.com" wrote: Hi I have the code If Cells(NB, 5).Value = "WALK" or Cells(NB, 5).Value = "BIKE" or Cells(NB, 5) .Value = "BUS" Then I would like to have WALK BIKE BUS ....... and editions in Sheet A Col A so my code line would be something like If Cells(NB, 5).Value = " Value in cells Sheet A Col A " Then Thanks in advance for any help -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200608/1 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Change Code from a Worksheet
Thanks Tom
Tom Ogilvy wrote: If not iserror(Application.Match(Cells(NB, 5).Value,worksheets("sheetA").columns(1),0)) Then Hi [quoted text clipped - 17 lines] Thanks in advance for any help -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200608/1 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| change the name of a worksheet/update VBA code | Excel Discussion (Misc queries) | |||
| Code to change formulae on worksheet? | Excel Programming | |||
| Code Conflicts With Worksheet Change Code | Excel Programming | |||
| Code not working after worksheet change. | Excel Programming | |||
| Worksheet change code | Excel Programming | |||
Hybrid Mode
