Excel VBA Selection and Navigation Techniques – part 2

Microsoft Excel VBA NavigationSee previous article: Excel VBA Selection and Navigation Techniques

In the last article I showed you how to make some basic navigation and selection techniques using the macro recorder. In this article I’ll show you how you can navigate and select when the data is more complex. Blank cells can be difficult to deal with if you don’t know how. I’ll take you through some of the methods I use when coding in Excel VBA. Continue reading “Excel VBA Selection and Navigation Techniques – part 2”

Excel VBA Selection and Navigation

Microsoft Excel VBA NavigationPeople often ask me about selection and navigation techniques using keyboard shortcuts when I’m teaching Macros in an Advanced Excel course. However, when I’m teaching students how to program for the first time in an Excel VBA course:

Question: How do I select or navigate using Excel VBA?

In this article I’m going to show you some basic techniques on how to go about it. Continue reading “Excel VBA Selection and Navigation”