ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Checkspelling with Autofilter (https://www.excelbanter.com/excel-programming/421550-checkspelling-autofilter.html)

bert

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.



All times are GMT +1. The time now is 09:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com