zirus
11-14-2006, 04:18 AM
hi
on my sheet i have a range ("myRange") which is the entire sheet.
on a userform i have a combobox populated off this sheet using myRange.
myRange is then sorted alphabetically using column A
the end result in the combobox is as i need it, but the problem is i get all the empty cells inserted into my combobox.
if i select and sort current region will this help, and how do select current region?
regards
:banghead:
on my sheet i have a range ("myRange") which is the entire sheet.
on a userform i have a combobox populated off this sheet using myRange.
myRange is then sorted alphabetically using column A
the end result in the combobox is as i need it, but the problem is i get all the empty cells inserted into my combobox.
if i select and sort current region will this help, and how do select current region?
regards
:banghead: