View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JoeS JoeS is offline
external usenet poster
 
Posts: 3
Default Macro to Recognize Dates

Hello.

I am attempting to write a Macro to automate some formatting I do as a
result of an ugly cut and paste into excel from Adobe Acrobat. I have the
manual process down and now I am having trouble automating it. I want the
macro to search column A for the words Print, Users, Status and Page; and any
dates. I then want the macro to delete the entire row. So far I have it
finding and deleting the text okay with a "Case" function. For some reason it
is not finding the dates.

Any ideas?
--
Joe S