Select 1st data cell after a filter

Posted by Chrisb on November 16, 2001 1:53 PM

When I Filter on a field, and then want to select the first cell in the filtered column, I don't know how to write a macro to go to that location. When I record a macro to copy over - it selects the first cell value ("U44"), but that won't always be the address, as the spreadsheet changes daily. Any suggestions?

thanks!!

chris

Posted by orangoetang on November 17, 2001 12:01 PM

Try this for autofilter on first row :

Range("a1").Select
Do Until ActiveCell.Offset(x+1,0).EntireRow _
.Hidden= False
x = x + 1
Loop
ActiveCell.Offset(x, 0).Select

good luck

Olaf

Posted by orangoetang on November 17, 2001 12:07 PM

Try this for autofilter on first row :

Range("a1").Select
Do Until ActiveCell.Offset(x+1,0).EntireRow _
.Hidden= False
x = x + 1
Loop
ActiveCell.Offset(x+1, 0).Select

good luck

Olaf

Posted by Chrisb on November 21, 2001 9:16 AM

Thanks Olaf - Works GREAT!! (NT)