Add outline border to dynamic range of cells

  • Hey guys!

    I have a range of data that starts at B5 through K5, and the number of rows down will grow or shrink dynamically depending on how much data has been inputted, so there is no set endpoint. Is there a way to generate an outline border around the entire range of cells used?

    Also, if I want to refer to that variable last row (i.e. if the range is B5:K33 one day, then B5:K42 the next) in vba for other coding purposes, is there a way to mention it in code?

    Thanks for your help!

Participate now!

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