i get a subscript out of range error #9....
the sheets tab name are Sheet 1, Sheet 2, etc. but i wanna use the Code
name because it is A, B, C, etc. I dont want to change the sheet tab
name. when u do
worksheets(combobox.value) , that things that the combobox.value is the
tab name but its not. its the code name.