View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default Delete a Column Based on User Entry

have a look in vba help for
INPUTBOX
FIND

--
Don Guillett
SalesAid Software

"Anice" wrote in message
...
I need to have a Macro that prompts the user for a year to delete. The
program would then search the worksheet for that year and delete all data
in
that column.

Any suggestions would be great!! Thanks