Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Question re For and Next
Am trying to search through all of the Column E, and if any cell = "SUPPORT"
AND the offset (0,4) to that cell < "", then it should put the word "Note 1" in the cell's offset (0,5). I keep getting the error message 'Next Without a For', but I have a 'for' in the code (see below). Can someone please advise what I'm doing wrong? With wks Set rngToSearch = .Range(.Range("E12"), .Cells(Rows.Count, "E").End(xlUp)) End With For Each rng In rngToSearch If rng.Value = "SUPPORT" And rng.Offset(0, 4) < "" Then rng.Offset(0, 5).Value = "Note 1" Next rng |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Question re For and Next
Paige,
You need and EndIf to match your If. Sometimes the messages get a little mixed up as to which pair of With/End With, For/Next, End/EndIf is missing a piece. hth, Doug "Paige" wrote in message ... Am trying to search through all of the Column E, and if any cell = "SUPPORT" AND the offset (0,4) to that cell < "", then it should put the word "Note 1" in the cell's offset (0,5). I keep getting the error message 'Next Without a For', but I have a 'for' in the code (see below). Can someone please advise what I'm doing wrong? With wks Set rngToSearch = .Range(.Range("E12"), .Cells(Rows.Count, "E").End(xlUp)) End With For Each rng In rngToSearch If rng.Value = "SUPPORT" And rng.Offset(0, 4) < "" Then rng.Offset(0, 5).Value = "Note 1" Next rng |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Question re For and Next
With wks
Set rngToSearch = .Range(.Range("E12"), .Cells(Rows.Count, "E").End(xlUp)) End With For Each rng In rngToSearch If rng.Value = "SUPPORT" And rng.Offset(0, 4) < "" Then rng.Offset(0, 5).Value = "Note 1" end if Next rng Regards, -- AP "Paige" a écrit dans le message de ... Am trying to search through all of the Column E, and if any cell = "SUPPORT" AND the offset (0,4) to that cell < "", then it should put the word "Note 1" in the cell's offset (0,5). I keep getting the error message 'Next Without a For', but I have a 'for' in the code (see below). Can someone please advise what I'm doing wrong? With wks Set rngToSearch = .Range(.Range("E12"), .Cells(Rows.Count, "E").End(xlUp)) End With For Each rng In rngToSearch If rng.Value = "SUPPORT" And rng.Offset(0, 4) < "" Then rng.Offset(0, 5).Value = "Note 1" Next rng |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Question re For and Next
With wks
Set rngToSearch = .Range(.Range("E12"), .Cells(Rows.Count, "E").End(xlUp)) End With For Each rng In rngToSearch If rng.Value = "SUPPORT" And rng.Offset(0, 4) < "" Then rng.Offset(0, 5).Value = "Note 1" end if Next rng -- Regards, Tom Ogilvy "Paige" wrote: Am trying to search through all of the Column E, and if any cell = "SUPPORT" AND the offset (0,4) to that cell < "", then it should put the word "Note 1" in the cell's offset (0,5). I keep getting the error message 'Next Without a For', but I have a 'for' in the code (see below). Can someone please advise what I'm doing wrong? With wks Set rngToSearch = .Range(.Range("E12"), .Cells(Rows.Count, "E").End(xlUp)) End With For Each rng In rngToSearch If rng.Value = "SUPPORT" And rng.Offset(0, 4) < "" Then rng.Offset(0, 5).Value = "Note 1" Next rng |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Quick Question re For and Next
Darn Darn Darn! I messed around with this for 2 hours. Sometimes I can't
see the forest for the trees. Thanks guys!!! "Tom Ogilvy" wrote: With wks Set rngToSearch = .Range(.Range("E12"), .Cells(Rows.Count, "E").End(xlUp)) End With For Each rng In rngToSearch If rng.Value = "SUPPORT" And rng.Offset(0, 4) < "" Then rng.Offset(0, 5).Value = "Note 1" end if Next rng -- Regards, Tom Ogilvy "Paige" wrote: Am trying to search through all of the Column E, and if any cell = "SUPPORT" AND the offset (0,4) to that cell < "", then it should put the word "Note 1" in the cell's offset (0,5). I keep getting the error message 'Next Without a For', but I have a 'for' in the code (see below). Can someone please advise what I'm doing wrong? With wks Set rngToSearch = .Range(.Range("E12"), .Cells(Rows.Count, "E").End(xlUp)) End With For Each rng In rngToSearch If rng.Value = "SUPPORT" And rng.Offset(0, 4) < "" Then rng.Offset(0, 5).Value = "Note 1" Next rng |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Question | Excel Discussion (Misc queries) | |||
Quick Question | Excel Discussion (Misc queries) | |||
Quick question - quick answer about assigning shortcut keys | Excel Programming | |||
Very Quick Question | Excel Programming | |||
Quick Question | Excel Programming |