Add outline border to dynamic range of cells

exelerated · Feb 21st 2017

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!

apo · Feb 21st 2017

Re: Add outline border to dynamic range of cells

Hi..

If the data in Column B is what will define your last row. then try this:

Code

Range("B5:K" & Range("B" & Rows.Count).End(xlUp).Row).BorderAround ColorIndex:=1, Weight:=xlThick

Change color and weight to suit..

exelerated · Feb 22nd 2017

Re: Add outline border to dynamic range of cells

Thank you! This works great

Add outline border to dynamic range of cells

Participate now!

Share