looking for a function

[Guest]

no, but I mean going to the last cell, if you have 1 2 3 4 5 6 your codes
goes until 3 then to 4 and then to 6, I want one code that when is executed
it goes to the really las cell (6)

 

[Guest]

Try Frank's 3rd option, as that takes you right down to the bottom, and then
up to the last cell with content