Macro button to go to the last non-blank cell in column

**miss_chloe** · 12-14-2014, 08:44 AM

I want to have macro form button with a code on it that when click the selected cell will be the last non-empty cell on the Column B. Note B1 is non-empty. because that's where I'm keeping the visibility of the button. Also the Column A is pre-filled with data(ID No.) thats why i need the code to check the Column B. Please let me know if there are more information needed.

**mehmetcik** · 12-14-2014, 08:58 AM

Please Login or Register  to view this content.

**miss_chloe** · 12-14-2014, 09:06 AM

Thanks for the response, i was able to get some help from existing forums.

Please Login or Register  to view this content.

**mehmetcik** · 12-14-2014, 09:33 AM

Hmm

Not sure that that is your answer.

Try the two buttons on this spreadsheet

The buttons use the codes above.

Button one selects B5

Button Two uses my code and selects B7. The last non empty cell.

**miss_chloe** · 12-14-2014, 10:03 AM

I was just reviewing my file, apparently my requirement is incomplete. Good thing you already replied. You are right, button 1 is the initial solution i got. Button2 is what i need, i just realized that there are empty cells in between non-empty cells, so it has to determine to extreme last cell that doesn't follow any non-empty cells. Thanks for the help.