Anybody tell me how to delete spaces from drop down list .
i did code like this:
with sh1.range("A2").validation
.delete
.Add type:xlvalidateList, AlertStyle:=xlValidAlertStop, operator:xlBetween, Formula:"=sheet2!AH2:AH1000"
.IgnoreBlank=True
.IncellDropDown=True
.InputTitle=""
.InputMessage= ""
.ShowInput= True
.ShowError= True
End With
Using this code i am getting blank in drop down, how to remove blank
Is there i need to do another loop
or need to select second range value and last used row in formula?
kindly help
i did code like this:
with sh1.range("A2").validation
.delete
.Add type:xlvalidateList, AlertStyle:=xlValidAlertStop, operator:xlBetween, Formula:"=sheet2!AH2:AH1000"
.IgnoreBlank=True
.IncellDropDown=True
.InputTitle=""
.InputMessage= ""
.ShowInput= True
.ShowError= True
End With
Using this code i am getting blank in drop down, how to remove blank
Is there i need to do another loop
or need to select second range value and last used row in formula?
kindly help