I'm attempting to teach myself this. What's wrong with my code here:
It continually bypasses my 'ElseIf' command and dumps straight to the 'Else' sequence.PHP Code:
Range("A1:F1").Select
Selection.Cut
If (A1 >= 10) Then
Sheets("10+ BBs").Select
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
ElseIf (A1 >= 9 And A1 < 10) Then
Sheets("9+ BBs").Select
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
Else
Sheets("8+ BBs").Select
Range("A65536").End(xlUp).Offset(1, 0).Select
ActiveSheet.Paste
End If
Thanks in advance for any help.
Bookmarks