Posted to microsoft.public.excel.programming

Ed[_9_]

external usenet poster

Posts: 194

Drop to next visible row when filtered?

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
Average Last 100 Filtered Visible rows	Sam via OfficeKB.com	Excel Worksheet Functions	4	September 18th 09 02:12 AM
countif only visible cells (filtered)	[email protected]	Excel Worksheet Functions	8	August 16th 07 04:39 PM
Copy visible cells on Filtered data	[email protected]	Excel Discussion (Misc queries)	4	July 18th 07 08:18 AM
count if on Visible - Filtered	tonyv	Excel Worksheet Functions	4	July 7th 07 07:34 PM
average of visible cells in a filtered range	dave roth	Excel Worksheet Functions	5	May 23rd 05 12:56 PM

All times are GMT +1. The time now is 02:17 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us