View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
bert bert is offline
external usenet poster
 
Posts: 30
Default 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.