Thanks FDibbins for your help - I appreciate the tips.
Leith Ross - I agree that VBA will be more fitting to my needs, thanks very much for the code.
Can you please tell me how to alter the border to only border around A:D instead of A:the last used cell in the row?
Does it do that because you declared Row as Long?
Dim Row     As Long
I appreciate your help!
Thanks!
Klotzy