Seeking recommendations for Excel VBA book for newbies (1 Viewer)

Philocthetes

Has a great deal to learn
Local time
Today, 01:24
Joined
Dec 19, 2017
Messages
28
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

..forever waiting... waiting for jellybean!
Local time
Today, 16:24
Joined
May 7, 2009
Messages
19,169
All free ebooks @ 777ebooks.com
 

Philocthetes

Has a great deal to learn
Local time
Today, 01:24
Joined
Dec 19, 2017
Messages
28
Thanks, arnelgp, but I'm looking for recommended titles, not places to get them.
 

jdraw

Super Moderator
Staff member
Local time
Today, 04:24
Joined
Jan 23, 2006
Messages
15,361
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

Has a great deal to learn
Local time
Today, 01:24
Joined
Dec 19, 2017
Messages
28
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

Super Moderator
Staff member
Local time
Today, 04:24
Joined
Jan 23, 2006
Messages
15,361
Glad to help.

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

arnelgp

..forever waiting... waiting for jellybean!
Local time
Today, 16:24
Joined
May 7, 2009
Messages
19,169
You can always search the site for excel vba.
 

Users who are viewing this thread

Top Bottom