hello,

I am sort of new to excel and am using it for work.

i need to create a shortcut (ideally ctrl-z) that will allow me to search column D which has a tonne of street names in it. i need to do a "custom" search and enter "contains" and then have the field on the right be left empty for me to enter what i need to enter.

I want to hit ctrl-z and have that blank field brought up for my to enter something to search for and have all those criteria met "custom-contain-??whatitype??"

I've tried using the record new macro function but it won't let me leave the dialogue box open for me to enter my street name.

i hope i explained that well enough....

basically i want to hit ctrl-z and have that custom-contains for column d open and ready for me to search.

thanks for any help you can provide.