Combobox userform issue with setting WS

here is my code

The issue is that I want my combobox6 (which is a list of all my sheets in my workbook) to be set as the "ws" - so as the code below is run on the user selected worksheet. but i get a runtimerror 424 Object required on the Set ws = ComboBox6.Value bit of code.

Any ideas>?

Please Login or Register  to view this content.

legendary that works brilliantly thanks!

rep added....