Look in the vba help index for FIND or FINDNEXT

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tree*Rat" wrote in message
6.253...
So far I have input box that a user adds a persons name. with this i need
it to search another workseet to find that name and then delete the
column.

i have the input box but dont know how to search the cells to find the
column (has to delete the column not the row).

help please!

thx