typed and moving

[asdzxc]

abcd .com (before moving) and after applying macro : abcd.com
plse write such macro

[SamT]

Need more information

[salmogomes]

Well, based on the information, see if you want this:

Go to VBE (Alt+F11) and put this in Object Sheet1 (or any sheet you want to modify):


Private Sub Worksheet_SelectionChange(ByVal Target As Range)

On Error GoTo a

Target = Replace(Target, " ", "")

a:

End Sub


Then write something in a cell and select it.

[asdzxc]

Well, based on the information, see if you want this:

Go to VBE (Alt+F11) and put this in Object Sheet1 (or any sheet you want to modify):


Private Sub Worksheet_SelectionChange(ByVal Target As Range)

On Error GoTo a

Target = Replace(Target, " ", "")

a:

End Sub


Then write something in a cell and select it.

[asdzxc]

In cell A1, I typed abcd .com and applied your macro but not working

[salmogomes]

You have to select cell again after the typing. Ex: write something in cell A1, then select cell A2 and select A1 again.

[Ringhal]

Or:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Target = Replace(Target, " ", "")
End Sub

[asdzxc]

Or:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error Resume Next
Target = Replace(Target, " ", "")
End Sub
Book1.xlsm attached. Run macro but not working.

[snb]

The best advice I can give you:

http://www.dummies.com/how-to/computers-software/programming/visual-basic.html

[Ringhal]

Read the link snb posted then view the attached file.