![]() |
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