Previewed your reply and didn't see the simpler coding.



"mudraker" wrote in message
...
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/