Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Subs and If's !
Hi - Ok, I'm a real newbie so this will be easy for someone :-)
I can't figure why this code loops around in strange ways and doesn't just step through doing the If's and Then's etc. I'll say no more at this stage because it's probably embarassingly blindingly obvious to everyone else! Private Sub Worksheet_Change(ByVal Target As Range) If Target.Value = "GD" Then Selection.Range("B1").Value = ("Graeme John Dixon") Else Selection.Range("B1").Value = ("I don't know you") End If If Range("B5").Value = ("Graeme John Dixon") Then Range("A1") = ("Test") End If End Sub -- Tachyon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
A problem with nested IF's | Excel Worksheet Functions | |||
A problem with nested IF's | Excel Worksheet Functions | |||
Subs | Excel Programming | |||
Newbie: problem referencing cell range between subs in the same mo | Excel Programming | |||
Nested IF's with Rank Problem | Excel Worksheet Functions |