View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Kaj Pedersen Kaj Pedersen is offline
external usenet poster
 
Posts: 11
Default Macro selecting the last used cell does not work

Range("A1").End(xlDown).Select

When I run a macro including this line everything normally works perfect.
That means the last cell is selected and the window scrolls to the actual
position.

However, I now have a problem with a macro where only the range is selected
but the window does not scroll to the position no matter where the position
is. I do not get any error messages. The line in question is the very last
line of my macro.

Does someone have an idea what can cause the problem and is there anything I
can do to improve the macro line?



Regards,

Kaj Pedersen