Spell check on specific columns in table

[kaus]

Hi
I want to run a spell check on 3 specific columns in a table. I've got the 'DoCmd.RunCommand acCmdSpelling' to start the spell checker, but need to select these columns prior to running this command. How would I select these columns in VBA so the user doesnt have to. I cant find a lot of documentation on this in the VBA on-line help.

Thxs

Pete

 

[yeungsprite]

For spellchecking a column such as the 'A' column you can use the Range property:

Dim somerange As Range
Dim i As Range

Set someRange = Range("A1", ActiveSheet.Cells.SpecialCells(xlLastCell))

For Each i In somerange
// i will cycle through words in column
Next i