I have this code in a form, which is designed to populate a combo box with all the values of non-empty rows in a given column.
The problem with this is that a "Runtime Error: 1004
Select method of Range class failed" occurs
' set variables
Dim wsSheet As Worksheet
Dim rngNext As...