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

 
 
 
Thread Tools Rate Thread Display Modes
Prev Previous Post   Next Post Next
Old 03-09-2018, 05:36 AM   #1
Philocthetes
Has a great deal to learn
Silver Supporter
 
Join Date: Dec 2017
Posts: 21
Thanks: 10
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
 

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:53 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