VBA to remove characters and commas

[Miya]

Hi, i need a macro to do the following,

1. Remove all commas from activeworksheet ( i notice i cant see the commas in excel, but when i open notepad i have commas in empty rows)

2. Remove all characters such as = + # ( ) $ from Column 5

Thanks

 

[Legacy 68668]

I think this is better

On Error Resume Next
With Columns(1)
    For Each r In .SpecialCells(2)
        If Len(r.Value) < 2 Then r.ClearContents
    Next
    .SpecialCells(4).EntireRow.Delete
End With
On Error GoTo 0

 

[Miya]

Thanks Seiya,

Everyone, , we should be greatful for Seiya's help, Seiya has helped countless number of people resolve difficult solutions. I'm always greatful that he helps me, and i can speak for quite a lot of people.

 

[Legacy 68668]

Hi Seiya,

Watches your post in this forum, u r the one who gives maximum solution or all solution in vba. Am also keen to learn vba, any suggestion from your side on how to go about will be really helpful.

Since I don't know how deep you know about vba and Excel, all I can say is;

1) just try anything with vba
2) browse object browser in vbe
3) surf the net or get vbHelp when you don't understand the meaning

If tried above and still don't understand, ask it to the board.

 

[vinod9111]

Since I don't know how deep you know about vba and Excel, all I can say is;

1) just try anything with vba
2) browse object browser in vbe
3) surf the net or get vbHelp when you don't understand the meaning

If tried above and still don't understand, ask it to the board.

Thanx for your reply. Actually speaking , have no knowledge about vba. The problem with vbhelp, it is not installed in my office. Anysite you are aware about which is good for the beginner.

 

[Legacy 68668]

Thanx for your reply. Actually speaking , have no knowledge about vba. The problem with vbhelp, it is not installed in my office. Anysite you are aware about which is good for the beginner.

It's a must item.