View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ajvasel ajvasel is offline
external usenet poster
 
Posts: 26
Default Moving the Cell Selection Within AutoFilter

In my program, when I enable AutoFilter, I want to select cell E4 and move
down 2 cells and enter text.

I tried using
ActiveCell.Offset(2, 0).Activate

but that just places the cell in E6. I want to be able to space down 2
cellls below E4 no matter what the row number is. How can I do this? Thx