Be the first user to complete this post
|
Add to List |
VBA-Excel: String Functions – String()
Description:
The String() function returns a string consisting a repeating characters of specified length.
Format:
String(number,character)
Arguments:
- number
- Mandatory
- Type: Numeric
- No of times the character to be repeated, means length of the returned string.
- Character
- Mandatory
- Type: Numeric
- Character to be repeated
Function FnString() intNumber = 10 strChar = "S" MsgBox String(intNumber, strChar) End Function

Also Read About Other String() Functions
INSTR() | InstrREV() | LCase()
Also Read:
- VBA-Excel : Strings Functions – Ucase
- VBA-Excel: Date-Time Functions – WeekDay() and WeekDayName()
- VBA-Excel: String Functions – Mid()
- VBA-Excel: String Functions – LTrim()
- VBA Excel - Cells, Ranges and Offset : Cells