Hi I wanted to run a spell check on a worksheet for just column A However for some reason it ignores column A and looks in B? I have tried two different methods both results are the same?
Can someone advise what I'm doing wrong?
Here is my code,
Thank You,
Mike
![]()
Sub SpellCheck() Dim Wks As Worksheet For Each Wks In Worksheets Wks.Select Columns("A:A").Select 'Range("A1:A5000").Select Cells.CheckSpelling SpellLang:=1033 Next Wks End Sub
Bookmarks