>>
>> *For i = LBound(arr) To UBound(arr)*
>>
>> *myWord = arr(i)*
>>
>> *Call mySpell*
>>
>> *If MyTest = False Then
>> Sheets("WrongWord").Range("A&q
quot;).Range("A2").End(xlUp).Row + 1).Value = myWord*
>
> *MyTest = False*
>
> *Next*
>
> *Sheets("WrongWord").Activate*
>
> * MsgBox "Total " &
> WorksheetFunctio
(ActiveSheet.Cells) & " Wrong Word Found in Data ",
vbInformation
End Sub
Sub mySpell()
MyTest = Application.CheckSpelling(myWord)
End Sub
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Anish Shrivastava
Sent: Monday, July 25, 2011 4
Hi,
Is it possible to store those keywords which is being found using Spellcheck
option in excel.
I have a list of values in Column "A" on which I run the spellcheck. Now I
want, excel(vba) to store those wrong values in sheet2 which is being found
by spellcheck function so that I can populate th
