View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Henrich Henrich is offline
external usenet poster
 
Posts: 53
Default Select the 2nd cell from the top in the column with filter

Hi all, i want the select with code the 2nd cell from the top in the column A
which has filtered data so i don't know which line it is (it could be any
depending on the filter settings) and i want to know the position of that
cell when i hit the commandbutton on that sheet. Thanks for help.

PS: Application.sendkeys"^{home}" didn't help

Henrich