WorksheetFunction.Rept Method (Excel)

Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.

expression .Rept(Arg1, Arg2)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

String

Text - the text you want to repeat.

Arg2

Required

Double

Number_times - a positive number specifying the number of times to repeat text.

Return Value

String

  • If number_times is 0 (zero), REPT returns "" (empty text).

  • If number_times is not an integer, it is truncated.

  • The result of the REPT function cannot be longer than 32,767 characters, or REPT returns #VALUE!.

Show: