Border around all cells in a column range to last row.

[enhydra]

Hi All,

I'm trying to create a border around all the cells in a column range that stops at the last used row. Attached is what I'm trying to work with.

Thanks,

E.

[teylyn]

Hello,

so, if the cell is emtpy, you apply a border. And if it is not empty, then you also apply a border. What's with that? Why the IF statements if the results are the same.

If you format everything with the same border, you don't need to loop through the range. Just apply the borders to the whole range in one step. Use the macro recorder for the required syntax.

[ikboy]

1 line :

Please Login or Register  to view this content.

[enhydra]

I only want it for a specific range of columns and row count will always be different. I have to apply it to a sheet after the sheet is created each time and each time the rows are different but the columns are the same. For ex. columns e thru m starting at row 8 until the last row of data in column B.

[ikboy]

or change the codes as

Please Login or Register  to view this content.

[enhydra]

That's it, Thank you so much ikboy.