2016Apress eBooksOpen access

Programming the Microsoft Excel Range Object

Flávio Morgado

Open full text 0 citations

Abstract

It can represent any number of cells, and in this chapter you will learn about the Range object and how to programmatically interact with it using VBA and its many properties and methods (it has no events), using some of the numerous Worksheet object methods to automate your worksheet and give it a professional look and feel. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

About this research paper

What this paper is about

It can represent any number of cells, and in this chapter you will learn about the Range object and how to programmatically interact with it using VBA and its many properties and methods (it has no events), using some of the numerous Worksheet object methods to automate your worksheet and give it a professional look and feel. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

It can represent any number of cells, and in this chapter you will learn about the Range object and how to programmatically interact with it using VBA and its many properties and methods (it has no events), using some of the numerous Worksheet object methods to automate your worksheet and give it a professional look and feel. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.

Key concepts: Worksheet, Visual Basic for Applications, Computer science, Object (grammar), Range (aeronautics), Component Object Model, Computer graphics (images), Microsoft excel

Related papers

Back to paper searchBrowse research topicsOriginal source
Programming the Microsoft Excel Range Object — Research Paper | ScholarLens