But for some reason Filter function is not working for me. is there any
alternative.

What does the Filter function do, exactly?

If you are using the 'Dependant Dropdowns' example I linked to.., there is no
Filter function. As you describe what you want to do, each Pincode selected
must also be the DefinedName of the range that contains its dropdown list.

If the list is NOT on the sheet containing the Dependant Dropdowns, the
DefinedName must be workbook level (global scope). Otherwise, the DefinedName
can be sheet level (local scope)

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion