Rediger

Del via


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.

Syntax

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 that you want to repeat.
Arg2 Required Double Number_times - a positive number specifying the number of times to repeat text.

Return value

String

Remarks

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 the #VALUE! error value.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.