View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Noel Boland Noel Boland is offline
external usenet poster
 
Posts: 2
Default Extracting info from different rows (& columns)

Dear all

Sorry to pester, but, I am being asked to do more and more spreadsheets with
several hundred lines of info, a lot of which needs deleting.
How do I get a simple macro that starts at Row a1, and continues to row
(say) 751(or whatever the final row is), but deletes any row in total that
has a
number 5 ( or other character )in the row on column A. although I am reading
walkenbach's book, I
cant find a good example that does this. Also in order not to pester, can
anyone recommend a good training book, because I intend to try and improve
my macro skills.