Microsoft Office Tutorials and References
In Depth Information
Try It
Cells on your worksheet that contain comments are regarded by Excel as SpecialCells . So are cells
containing Data Validation, or cells that contain formulas, or cells that contain constants, such as
text or data you have manually entered. With the combinations of SpecialCells , the possibilities
are enormous for identifying various kinds of ranges based on all sorts of criteria.
Say in range A1:A10 you have some cells that contain formulas, some cells that contain numbers
you have manually entered, and some cells that contain nothing. If you want to select all individual
cells in range A1:A10 that contain formulas, and not include in your selection any of the other cells
in that range, this macro would do that:
Sub FindFormulas()
Range(“A1:A10”).SpecialCells(xlCellTypeFormulas).Select
End Sub
Try iT
In this lesson you practice with the useful Intellisense tool to help you become familiar with the
properties and methods of VBA objects. VBA’s “ IntelliSense ” feature offers you VBA syntax
assistance in the VBE. You learn how to use it for the purpose of seeing a list of your objects’ properties
and methods in your VBE Code window.
lesson requirements
None.
step-by-step
VBA’s IntelliSense feature is an incredibly useful tool that helps you write your macros faster and
smarter. I use it all the time to help me write code in the proper VBA syntax. As you learned, VBA
has hundreds of objects and each object can have dozens of methods and properties. IntelliSense
can display a list of an object’s methods and properties while you are typing your code, and it can
quickly call the Help feature for a topic you select.
1.
Open Excel and press Alt+F11 to go to the Visual Basic Editor.
2.
If you have not already done so, from the VBE menu, click Tools Options as shown in
Figure 7-1.
figurE 7-1
 
Search JabSto ::




Custom Search