Macro selecting the last used cell does not work

  • Thread starter Thread starter Kaj Pedersen
  • Start date Start date
K

Kaj Pedersen

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
 
Hi,
I have figured out the problem.
In the first place I was not aware that I had the line
"Application.ScreenUpdating = False" among hundreds of lines.
I think the line came from partial recording of the macro.

Kaj Pedersen
 
Back
Top