PC Review


Reply
Thread Tools Rate Thread

Checkspelling with Autofilter

 
 
Bert
Guest
Posts: n/a
 
      19th Dec 2008
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).CheckSpelling
("NAMES.DIC")
Thanks.

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
CheckSpelling function Mike Microsoft Excel Programming 4 15th Sep 2009 11:57 PM
CheckSpelling =?Utf-8?B?SmltIE1jQw==?= Microsoft Excel Programming 3 25th Sep 2006 04:14 PM
CheckSpelling a Textbox Stuart Microsoft Excel Programming 5 19th Mar 2005 06:40 AM
CheckSpelling + TextBox Stuart Microsoft Excel Programming 0 27th Jul 2004 06:59 AM
TextBox - CheckSpelling question Stuart Microsoft Excel Programming 2 24th Jul 2004 08:41 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:58 AM.