AutoFill border

Hi all,

Goal: if a value is in Column B, have the inside border auto fill down, in Columns D through BE.
From Row 5 down to that row.

This works for the row where i put the value in Column B but if i clear out some of the bottom rows
in Column B the Format stays.

I guess what i am trying to do is clear the format on that row if the value
in Column B is tken out. Been trying some IF / ELSE stuff but to no avail.

Please Login or Register  to view this content.

Hi mudraker,

Thanks for your reply. As written your code clears all the Borders in Columns
D:BE as i asked, but my code dosen't fill them back in, down to the last cell in Column B.

So i will go back to the drawing board.

Seems this line isn't doing anything.

Please Login or Register  to view this content.

I am trying to make it start on line 5, going down.

Originally Posted by mudraker

Try clearing the borders for columns D to BE - all rows then have your macro apply border formating

Please Login or Register  to view this content.

Your code starts at the bottom row in column 5 (E) and goes up. But you do not use the variable result within your code.



Try changing your code the following 2 commands

Please Login or Register  to view this content.

Ok here is where i am at:

It seems that it does everything i need except when i put a value
in Column B, the formating occurs only on that row and not from
row 5 down to that line. So all the rows in between are 'no borders'

Please Login or Register  to view this content.

Originally Posted by mudraker

Your code starts at the bottom row in column 5 (E) and goes up. But you do not use the variable result within your code.



Try changing your code the following 2 commands

Please Login or Register  to view this content.