I am in the process of trying to create a macro that will insert two spaces to the beginning of each cell in an entire column. I have created it to successfully select an entire column but I can't seem to get the macro to add the two spaces before the text in the cell. My macro is as follows:
Sub Macro3()
'
' Macro3 Macro
'
' Keyboard Shortcut: Ctrl+z
'
ActiveCell.Columns("A:A").EntireColumn.Select
'cell.Value = cell.Value & " "
ActiveColumn.Value = ActiveColumn.Value & " "
End Sub
Any ideas on what is wrong in my code? Thank you.
Bookmarks