Format Cells between empty rows until there is no more data

Hi and welcome to the forums,

try this:

Please Login or Register  to view this content.

I put your code at the end of what I am using and I get this error:
Compile error:
Duplicate declaration in current scope.

The "i As Byte" in the "Dim i As Byte" line is highlighted.

I have this code above what you have.

Please Login or Register  to view this content.

Hi,

The code is not intended to be pasted below other code, especially when you don't know whats happening there, use it as a separate sub by calling it at the end of your main procedure.

Hi,

I assume its in the following line caused by a missing worksheet called "Start"

Please Login or Register  to view this content.

Can the sheetname change or is it every time the same you run the code on?

Hi,
try

Please Login or Register  to view this content.

What I did:
Instead of using the "currentregion" of a cell I check the max number of columns in row 1 first to determine how many columns should be "bordered"

Based on your last post in this thread, its apparent that you are satisfied with the solution(s) you've received and have solved your question, but you haven't marked your thread as "SOLVED". I will do it for you this time.

In future, to mark your thread as Solved, you can do the following -
Select Thread Tools-> Mark thread as Solved.

Incase your issue is not solved, you can undo it as follows -
Select Thread Tools-> Mark thread as Unsolved.

Also, since you are relatively new to the forum, i would like to inform you that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post which helped you. This adds to the reputation of the person who has taken the time to help you.