Insert Space using VBA Code

[zaska]

HI all,

I want to insert a single space at the beginning of each text contained in a cell.

How can i do this with VBA code?

Thank you

 

[VoG]

Try selecting the range then running

Sub space()
Dim c As Range
For Each c In Selection
    c.Value = " " & c.Value
Next c
End Sub

 

[zaska]

Thank you for the quick Reply Sir