Seeking recommendations for Excel VBA book for newbies

[Philocthetes]

The title pretty much says it all.

I'm looking for something that could help me answer questions for myself, e.g. "If I've got a bunch of find/delete blocks in a macro, how do I get the macro to keep moving if one of the row sets it is working doesn't contain the row I want to delete?"

Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Find(What:="8", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
ActiveCell.Rows("1:1").EntireRow.Select
Selection.Delete Shift:=xlUp

Range("A1").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.Find(What:="40", After:=ActiveCell, LookIn:=xlFormulas, LookAt _
:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _
False, SearchFormat:=False).Activate
ActiveCell.Rows("1:1").EntireRow.Select
Selection.Delete Shift:=xlUp

 

[arnelgp]

All free ebooks @ 777ebooks.com

 

[Philocthetes]

Thanks, arnelgp, but I'm looking for recommended titles, not places to get them.

 

[jdraw]

You may find a lot of info and examples at Paul Kelly's site.
I'm not an excel person, but I have watched his live videos.

 

[Philocthetes]

Thanks, jdraw. I've just started watching some of his content on Lynda.com. The web site looks to be far more helpful for reading-oriented folks like me.

 

[jdraw]

Glad to help.

Paul has free video sessions --I get emails of upcoming things.

 

[arnelgp]

You can always search the site for excel vba.