Go Back   Access World Forums > Apps and Windows > Visual Basic

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 03-09-2018, 05:36 AM   #1
Philocthetes
Has a great deal to learn
Silver Supporter
 
Join Date: Dec 2017
Posts: 16
Thanks: 8
Thanked 0 Times in 0 Posts
Philocthetes is on a distinguished road
Seeking recommendations for Excel VBA book for newbies

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

Philocthetes is offline   Reply With Quote
Old 03-09-2018, 08:10 AM   #2
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,194
Thanks: 54
Thanked 1,986 Times in 1,899 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Seeking recommendations for Excel VBA book for newbies

All free ebooks @ 777ebooks.com
__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Old 03-09-2018, 08:24 AM   #3
Philocthetes
Has a great deal to learn
Silver Supporter
 
Join Date: Dec 2017
Posts: 16
Thanks: 8
Thanked 0 Times in 0 Posts
Philocthetes is on a distinguished road
Re: Seeking recommendations for Excel VBA book for newbies

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

Philocthetes is offline   Reply With Quote
Old 03-09-2018, 08:49 AM   #4
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,371
Thanks: 49
Thanked 1,844 Times in 1,794 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: Seeking recommendations for Excel VBA book for newbies

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.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is online now   Reply With Quote
The Following User Says Thank You to jdraw For This Useful Post:
Philocthetes (03-09-2018)
Old 03-09-2018, 09:03 AM   #5
Philocthetes
Has a great deal to learn
Silver Supporter
 
Join Date: Dec 2017
Posts: 16
Thanks: 8
Thanked 0 Times in 0 Posts
Philocthetes is on a distinguished road
Re: Seeking recommendations for Excel VBA book for newbies

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.
Philocthetes is offline   Reply With Quote
Old 03-09-2018, 09:05 AM   #6
jdraw
Super Moderator
 
jdraw's Avatar
 
Join Date: Jan 2006
Location: Ottawa, Ontario, Canada;West Palm Beach, Florida
Posts: 11,371
Thanks: 49
Thanked 1,844 Times in 1,794 Posts
jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice jdraw is just really nice
Re: Seeking recommendations for Excel VBA book for newbies

Glad to help.

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

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
jdraw is online now   Reply With Quote
Old 03-09-2018, 05:58 PM   #7
arnelgp
Registered User
 
arnelgp's Avatar
 
Join Date: May 2009
Location: somewhere out there
Posts: 6,194
Thanks: 54
Thanked 1,986 Times in 1,899 Posts
arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough arnelgp is a jewel in the rough
Re: Seeking recommendations for Excel VBA book for newbies

You can always search the site for excel vba.


__________________
"Never stop learning, because life never stops teaching"
arnelgp is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Question Book recommendations jonathanchye General 1 10-26-2012 12:28 PM
Question Second Novice Book - Any Recommendations? Blafin General 6 12-26-2008 08:34 AM
Book Recommendations? Alisa General 0 03-16-2008 09:46 AM
Book Recommendations? Bek General 8 08-01-2007 11:34 PM
Seeking forums for Excel and Visual Studio kupe Modules & VBA 2 10-07-2003 12:42 AM




All times are GMT -8. The time now is 02:09 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World