Offset down on a filtered list

[vjay883]

Hi,

What I am trying to do is select a column and filtering for blanks.

I want to offset down one - but when I use the below code it doesnt ignore the filtered rows.
ActiveCell.Offset(1,0).SelectI need the code to ignore all filtered cells and select the first empty cell. Thanks in advance. V</PRE>

 

[Peter_SSs]

Welcome to the MrExcel board!

We don't know what/where you have on your sheet or what the ActiveCell is but see if this does something like what you want.

With Intersect(ActiveSheet.AutoFilter.Range, ActiveCell.EntireColumn)
  .Offset(.Rows.Count).Resize(1, 1).Select
End With