Checkspelling with Autofilter
I'm trying to use CheckSpelling on specific cells (selected by autofilter)
in one column of data; however, it appears as if CheckSpelling is checking
all the data in the column, not just the data that is displayed with the
autofilter. Here's what I have now:
Set Trg = Worksheets("SData").AutoFilter.Range
Trg.Columns(clm).SpecialCells(xlCellTypeVisible).C heckSpelling
("NAMES.DIC")
Thanks.
|