Strange!! but I got it working with the same code below.
Thanks a lot for this.
Anish
On Mon, Jul 25, 2011 at 7:46 PM, Anish Shrivastava wrote:
> Hi Rajan,
>
> Thanks for your quick response. It works fine.
> However I made few changes according to my further requirements and then It
> doesnt cat
Hi Rajan,
Thanks for your quick response. It works fine.
However I made few changes according to my further requirements and then It
doesnt catch the wrong words.. It's giving me zero..
Please have a look. I have highlighted the changes I made.
Let me know Where am I wrong?
Try this , Hope I did understand your Query..
Public MyTest As Boolean
Public myWord As String
Sub GetText()
On Error Resume Next
Dim ws As Worksheet
Dim st As String
Dim arr() As String
Dim cell As Range
Set ws =
