2.2.3.13 filltext

Brief Information

Fill cells in worksheet range with random letters

Command Line Usage

1. filltext

2. filltext group:=52

3. filltext group:=10 rng:=[Book1]Sheet1!Col(A)

X-Function Execution Options

Please refer to the page for additional option switches when accessing the x-function from script

Variables

Display
Name
Variable
Name
I/O
and
Type
Default
Value
Description
Group group

Input

int

26

Specify how many letters available for filling into cells, that will be a group. Group generated by English alphabet. For example, if the value is 4, the group will contain 4 letters for selecting randomly to fill the cells, including A, B, C, and D. And then for each cell, it will pick a letter from these four to fill. Default value is 26, which means all alphabet letters are available.

Input rng

Input/Output

Range

<active>

Specify destination range to fill with random text.

Description

This function fills the cell in the specified range with random text. We can set the letter group number.