Posted to microsoft.public.excel.programming

Ed[_9_]

external usenet poster

Posts: 194

Repost: Dop to next visible row when filtered?

Originally posted 10/10/03:

I want my macro to enter a formula in a cell, then drop to the next visible
cell one row down when I'm in AutoFilter mode. I tried
ActiveCell.Offset(1, 0).Activate
but that drops it to the next row even if it's hidden by the filter. Can I
put SpecialCells(xlVisible) in here somehow?

Ed

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Repost - Functions on filtered data	LiAD	Excel Worksheet Functions	0	March 25th 10 04:34 PM
count if on Visible - Filtered	tonyv	Excel Worksheet Functions	4	July 7th 07 07:34 PM
REPOST: Count certain records in filtered data	Steve Simons	Excel Discussion (Misc queries)	5	August 19th 06 12:48 PM
Repost - Track Changes not visible	Angie M.	Excel Discussion (Misc queries)	1	May 10th 06 10:48 PM
Drop to next visible row when filtered?	Ed[_9_]	Excel Programming	2	October 11th 03 01:32 AM

All times are GMT +1. The time now is 11:49 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us