Find Last Blank Row Without Acticate and selecting

[HaroonSid]

hi,
i want to show last blank row without activate and selecting it

like, this code is selecting last blank row of COlumn(K)

Please Login or Register  to view this content.

like, this code is activating last blank row of COlumn(K)

Please Login or Register  to view this content.

thank you

[sintek]

Please Login or Register  to view this content.

[Kaper]

But how do you want to show?
Of course, you could communicate it to user, like:

Please Login or Register  to view this content.

or may be starting from very bottom (not just from row 500):

Please Login or Register  to view this content.

or assign row/column to variables

Please Login or Register  to view this content.

EDIT: BTW. Indeed, as noticed above all codes from original post and from this post give last filled cell, not first blank

[HaroonSid]

@sintek
i want to go to last blank cell like hyperlink does

[HaroonSid]

ok
i think i am not clearing what i need

i want to centralize the Last blank cell of sheet

[HaroonSid]

In this code according my data the answer is = $k$109

Please Login or Register  to view this content.

now i want to show k109 row in the center

Attachment 529894

[sintek]

Please Login or Register  to view this content.

[HaroonSid]

Thank you sintek for trying to help me
actually if i run this macro from my userform then my combobox2 lost his focus if i select last blank row or i activate last blank row

so i was trying to do it without losing focus of my rate.combobox2.setfocus

[HaroonSid]

Found why combobox2 losing focus
so starting new thread

thank you