Excel VBA formulas for Spreadsheet by Sharath Kumar Peechara - HTML preview

Exercise 25: Space Function

To create this Function, execute the following steps

1. Open Excel VBA (Alt + F11)
2. Insert a New Module
3. In the Project Explorer, double click on the Module
4. Add the following code line:

This Code lines will create function Spce() In Cell B1 Type

= Spce(3)

In D1 As =A1&B1&C1

2. Use Keyboard space button