Add thick Border around range after deleting empty rows - MACRO

Hello,

I have created a macro that checks a range of data and removes an empty row. It's working perfectly. I am trying to write some code now to place a thick border around the entire new range after the blank rows are deleted.

Please Login or Register  to view this content.

Is someone able to provide me with an example of how to approach this next step? I thought it might be easier before the removed row, to have a bit of code which finds the last row in the range first, then add the line.

How about this:

Please Login or Register  to view this content.

Hi,

Thanks for the reply. I think i have not provided enough info in the intial post therefore the solution posted works but not what i after.

The data range which needs to be boxed is ("C18:Z30") minus the deleted rows. For Example, if the range ("C18:Z30") has 2 rows deleted, the box should go around ("C18:Z28")

Apologies, I hope that make sense?

kind regards

dv

Hi jindon

That has worked well, Thank you. The only issue now it is putting a border around every cell. I only require a thick border around the entire range, not the actual cells.

Is there a way to achieve that in a similar way you have shown?

Try:

Please Login or Register  to view this content.

Thanks all

below was the final code that worked.

Please Login or Register  to view this content.