vba macro coding in excel

[Guest_imported]

hi guys,

would anyone know how to do the following?

take a label in an active cell and then compare it to a specified range.
if the label is within the range then it will do nothing, else it would add it to the range

i cant seem to get this to work using nested if's so if anyone out there could help it would be much appreciated =]

 

[GBall]

This might help


'P1 points to the last entry in the userlist populated at startup (or whatever range you want)
dim entry_found as boolean
For i = 1 To Worksheets("CumSeries&quot.Range("P1&quot.Value
strRange = "" & "P" & (1 + i) & "" 'ignore P1
If Worksheets("Cumseries&quot.Range(strRange).Value = yournewvalue Then
entry_found = true
exit for
End If
Next i

if not entry_found then
i = i + 1
strRange = "" & "P" & (1 + i) & ""
Worksheets("Cumseries&quot.Range(strRange).Value = strUserID = yournewvalue
end if