View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kevryl Kevryl is offline
external usenet poster
 
Posts: 89
Default Using Arrow keys in a macro

I need to use an arrow key in a macro to move to the next row down. The
"offset" command is of no use because I have filtered the rows by this stage
and it lands the cursor in a filtered out row, rather than the next visible
row down. I suspect that if I can find out how to use the "End(x1down)"
without the "End" it will operate only across the visible rows, because
"End(x1down)" does .

Does anyone know the answer to the problem?