Re: $$Excel-Macros$$ Re: Remove Punctuation

2012-06-27 Thread Deba Ranjan
Thanks Lait Ji, Working fine. Thanks & Regards, *Deba Ranjan P* On Wed, Jun 27, 2012 at 4:20 PM, Lalit_Mohan wrote: > Sub RemovePunctuation() > Dim arrPunc As Variant > Dim lngLoop As Long > Dim rngCol As Rang

$$Excel-Macros$$ Re: Remove Punctuation

2012-06-27 Thread Lalit_Mohan
Hi Ranjan, Please try this. Sub RemovePunctuation() Dim arrPunc As Variant Dim lngLoop As Long Dim rngCol As Range Dim rngRangeAs Range arrPunc = Array(".", "!", ":", ";", "-", "#", "(