Does your 2nd combo box gets its details frm c1 to c5?



To simplify your posted code Try this



Sub SelectCorrectList()
Application.ScreenUpdating = False
Select Case Range("E10")
Case Is = 1
Range("F1:F5").Copy
Case Is = 2
Range("G1:G5").Copy
Case Is = 3
Range("H1:H5").Copy
Case Is = 4
Range("I1:I5").Copy
Case Is = 5
Range("J1:J5").Select
Case Else
Exit Sub
End Select
Range("C1").PasteSpecial
Application.CutCopyMode = False
End Sub


---
Message posted from http://www.ExcelForum.com/