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 : 3D-Ranges – FillAcrossSheets Method
- VBA-Excel: Arrays – One Dimension, Static Array
- VBA-Excel: Array Functions – Filter()
- VBA-Excel: Array Functions – LBound and UBound()
- VBA-Excel: Arrays – One Dimension, Dynamic Array
- VBA-Excel: String Functions – Trim()
- VBA-Excel : Strings Functions – InstrRev
- VBA-Excel: Delete Blank Rows from Excel Work Sheet