Command Button Keeping Screen Position

[Mordred]

Hi all,

I am using a command button to enable the user to skip down to the last row of data in column B. The reason is because the user will be loading this particular sheet with source data. So, he will paste in the first table, click the button and the next empty cell down column B will be selected and readied for the next table. Is there a way that the command button can stay on the view screen while going down the rows?

Kindest Regards,
Michael

[tigeravatar]

Michael,

For something like that I'd recommend freezing panes so that the button is always visible within the frozen panes.

Hope this helps,
~tigeravatar

[Mordred]

You know, I should have thought about that. Thank you.