Forum Discussion

bvelke's avatar
bvelke
Brass Contributor
May 30, 2019

Button to jump and autofill?

Is it possible to create a button at A1 that will (1) jump to the first blank cell in that column and (2) fill that cell with today's date (as a value, not a function)?   As my first attempt, I cre...
  • Haytham Amairah's avatar
    Haytham Amairah
    Jun 01, 2019

    bvelke

     

    The solution is to make the starting cell in the macro always the first left-most cell in the table which is A5.

    Which require changing the code a little bit as follows:

    Sub JumpToTheFirstBlankCell()
    Range("A5").End(xlDown).Offset(1, 0).Select
    Selection.Value = Date
    End Sub

     

    Hope that helps

Resources