Be the first user to complete this post
|
Add to List |
VBA-Excel: String Functions – Space()
Description:
The Space() function returns a string consisting a specified number of spaces.
Format:
Space (intNumberOfSpaces)
Arguments:
- intNumberOfSpaces
- Mandatory
- Type: Numeric
- Number of spaces you want in the string.
Function FnSpace() intNos = 25 MsgBox "Perfect example of" & Space(intNos) & "Space" End Function
Also Read About Other String() Functions
INSTR() | InstrREV() | LCase()
Also Read:
- VBA-Excel: Arrays – Two Dimensional, Static Array
- VBA-Excel: Date-Time Functions – WeekDay() and WeekDayName()
- VBA-Excel: Select and Activate Cells - Activate
- VBA-Excel: Date-Time Functions – DateValue()
- VBA Excel - Cells, Ranges and Offset: Refer Range by using A1 Notations