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!