Need help on Excel 2003 Macro Visible Property
 

I am trying to help a friend "spiffy" up a sign up sheet. I haven't done any
programming in 10 years, and then it was self-taught and only as a side
action to get my main job done.
He has an Autofilter on the Headings row so he can click on Tuesday, for
example, or Saturday, etc. There really isn't anything to identify the sheet
as Tuesday, for example, or Saturday, etc.
Would it be possible to start the cursor in, say, the Headings row, and then
move it down a cell at a time, checking each cell if it is visible or not,
then stopping at the first cell that is visible and copying the information
to the top of the page. That way a sheet could be indentified as Tues, or
Friday, etc. It would also preclude the need to create a separate page for
each day.
Would appreciate the help.
Thanks.

Need help on Excel 2003 Macro Visible Property
 

See http://www.ozgrid.com/VBA/autofilter-criteria.htm for a possible
solution...

"TheGrimbler" wrote:

I am trying to help a friend "spiffy" up a sign up sheet. I haven't done any
programming in 10 years, and then it was self-taught and only as a side
action to get my main job done.
He has an Autofilter on the Headings row so he can click on Tuesday, for
example, or Saturday, etc. There really isn't anything to identify the sheet
as Tuesday, for example, or Saturday, etc.
Would it be possible to start the cursor in, say, the Headings row, and then
move it down a cell at a time, checking each cell if it is visible or not,
then stopping at the first cell that is visible and copying the information
to the top of the page. That way a sheet could be indentified as Tues, or
Friday, etc. It would also preclude the need to create a separate page for
each day.
Would appreciate the help.
Thanks.

Need help on Excel 2003 Macro Visible Property
 

Since then I discovered (I think) that the Visible Property is not available
with what I was trying to do. Duh. But I did discover that I can use the
AutoFilterMode to find out if AutoFilter is on or not, then to find out the
value of Criteria1. Sometimes I can get Criteria1 to work, sometimes not.

"TheGrimbler" wrote:

I am trying to help a friend "spiffy" up a sign up sheet. I haven't done any
programming in 10 years, and then it was self-taught and only as a side
action to get my main job done.
He has an Autofilter on the Headings row so he can click on Tuesday, for
example, or Saturday, etc. There really isn't anything to identify the sheet
as Tuesday, for example, or Saturday, etc.
Would it be possible to start the cursor in, say, the Headings row, and then
move it down a cell at a time, checking each cell if it is visible or not,
then stopping at the first cell that is visible and copying the information
to the top of the page. That way a sheet could be indentified as Tues, or
Friday, etc. It would also preclude the need to create a separate page for
each day.
Would appreciate the help.
Thanks.