Writing Excel Macros with VBA by Steven Roman PhD
Author:Steven Roman, PhD [Steven Roman, PhD]
Language: eng
Format: epub
Tags: COMPUTERS / Programming Languages / Visual BASIC
ISBN: 9780596555238
Publisher: O'Reilly Media
Published: 2008-12-16T16:00:00+00:00
Figure 19-2. The range as a union
The code:
Dim rng As Range Set rng = Range("B4:C5, E2:E7") MsgBox rng.Columns(1).Cells(1, 1).Value
displays a message box containing the x shown in cell B4 in Figure 19-2 because the indexes in the Cells property are taken relative to the upper cell in the leftmost area in the range.
Note that we can use either integers or characters (in quotes) to denote a column, as in:
Columns(5)
and:
Columns("E")
We can also write, for instance:
Columns("A:D")
to denote columns A through D. Similarly, we can denote multiple rows as in:
Rows("1:3")
Since a syntax such as:
Columns("C:D", "G:H")
does not work, the Union method is often useful in connection with the Columns and Rows methods. For instance, the code:
Dim rng As Range Set rng = Union(Rows(3), Rows(5), Rows(7)) rng.Select
selects the third, fifth, and seventh rows of the worksheet containing this code or of the active worksheet if this code is in a workbook or standard code module.
Download
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.
Ajax | Assembly Language Programming |
Borland Delphi | C & C++ |
C# | CSS |
Compiler Design | Compilers |
DHTML | Debugging |
Delphi | Fortran |
Java | Lisp |
Perl | Prolog |
Python | RPG |
Ruby | Swift |
Visual Basic | XHTML |
XML | XSL |
Deep Learning with Python by François Chollet(12563)
Hello! Python by Anthony Briggs(9911)
OCA Java SE 8 Programmer I Certification Guide by Mala Gupta(9794)
The Mikado Method by Ola Ellnestam Daniel Brolund(9775)
Dependency Injection in .NET by Mark Seemann(9335)
Algorithms of the Intelligent Web by Haralambos Marmanis;Dmitry Babenko(8292)
Test-Driven iOS Development with Swift 4 by Dominik Hauser(7758)
Grails in Action by Glen Smith Peter Ledbrook(7693)
The Well-Grounded Java Developer by Benjamin J. Evans Martijn Verburg(7557)
Becoming a Dynamics 365 Finance and Supply Chain Solution Architect by Brent Dawson(7018)
Microservices with Go by Alexander Shuiskov(6786)
Practical Design Patterns for Java Developers by Miroslav Wengner(6698)
Test Automation Engineering Handbook by Manikandan Sambamurthy(6638)
Secrets of the JavaScript Ninja by John Resig Bear Bibeault(6409)
Angular Projects - Third Edition by Aristeidis Bampakos(6047)
The Art of Crafting User Stories by The Art of Crafting User Stories(5579)
NetSuite for Consultants - Second Edition by Peter Ries(5510)
Demystifying Cryptography with OpenSSL 3.0 by Alexei Khlebnikov(5312)
Kotlin in Action by Dmitry Jemerov(5061)
