Big Chemical Encyclopedia

Chemical substances, components, reactions, process design ...

Articles Figures Tables About

Getting Data from the Worksheet

In traditional programming (such as with C++), the source of input data is usually either the keyboard or (usually when there are lots of data) a file. When using VBA, which is an integral part of Excel, the natural source of input is from the Worksheet itself. [Pg.38]

The Cells method treats the spreadsheet as a two-dimensional array representing the rows and columns. If the variable ActRow is 3, for example, then the variable [Pg.38]

InputNumber is assigned whatever value is contained in the cell in the third row and first colnmn. It is possible using the Range object to write a statement that inpnts values from a collection of cells (but this tends to make things more complex than they need be). [Pg.39]


See other pages where Getting Data from the Worksheet is mentioned: [Pg.38]   


SEARCH



The Data

Worksheet from

Worksheets

© 2024 chempedia.info