LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Navigating through filtered cells

Hi,
I'd like to step through rows of a column of cells
which are visible due to me setting a filter. I may want
to assign values to empty cells based on the values of
neighboring rows. Since the data is filtered, there may
be many "behind-the-scenes" rows that are not shown to
me. What are the VB navigation commands that I can use to
step my way through each row and reference only the
visible cells immediately above and below cells of
interest?

Thanks much,

Reney
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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
Navigating between cells [email protected] Excel Discussion (Misc queries) 3 June 30th 06 02:26 PM
Navigating in filtered rows anandmr65 Excel Discussion (Misc queries) 2 February 21st 06 10:04 AM
Navigating through Cells DanielPolak Excel Discussion (Misc queries) 2 February 13th 06 02:02 PM
Navigating a filtered list Hafeez Esmail Excel Programming 3 December 11th 03 08:17 PM
Navigating cells in VBA charlieb Excel Programming 3 September 10th 03 02:24 PM


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"