VBA to fill in blanks

  • Hi,

    I'm stuck on a problem and don't even know where to start.

    I need to fill all the blank cells in Row A with the number between the highlighted rows.

    The amount of rows varies per report

    See before and after attachments



  • Give this a try, it works with the uploaded workbook.


  • norie

    Love your usage of CurrentRegion.Columns(1) ... in this context .... very handy :thumbup:


    If you feel like saying "Thank You" for the help received, do not hesitate to click the "Smiley" icon, below, in the bottom right corner :)

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!