Auto makeing of borders

Hi

I'm tryn to make this happen:

When the values are copyed from workbook1 to a workbook template I want the values that were copyed there to have borders so you can read it easyer.
Here's what I'm using:

Please Login or Register  to view this content.

And it works fine untill I have a few cells in colum 6 empty.

I've explaind it in the attachment again.
And I can't set the borders to already be there becose the range I copy there is dynamic that is Sometimes 6 Columns and 3 Rows and sometimes 6Columns and 15Rows and so on.

Please help me fix this. I know what the problem is but I don't know how to fix it. I need it to count the last cell as not blank so it makes borders from Row1 Column 6 to Row (10) Column 6.

maybe this will help

Please Login or Register  to view this content.