Example

Using the Series Method.

Using the Series Method code snippet.

The following is a simple example of how to use the Series Method. The Series Method fills only the cells in the first selected column.

    Dim ret as string
    'Use the SRow, SRow2, SCol, and SCol2 properties
    'to validate the selection here.
    'Display an input box to get the increment to fill
    'the selection with.
    ret = InputBox("Enter an integer from 1 to 10")
    DGrid1.Series Val(ret)