Fill cells in worksheet range with random letters
1. filltext
2. filltext group:=52
3. filltext group:=10 rng:=[Book1]Sheet1!Col(A)
Please refer to the page for additional option switches when accessing the x-function from script
Input
int
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/Output
Range
Specify destination range to fill with random text.
This function fills the cell in the specified range with random text. We can set the letter group number.