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.

« For Each Subtotal/Bold, Add xlDouble | VB code »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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