remove borders below last row of data

[Gti182]

hi all,

struggling with what should be an easy bit of code.

Trying to select all cells below the last row of data based on column B and remove borders.

so far i have this.

Please Login or Register  to view this content.

[Gti182]

managed to get this to work

Please Login or Register  to view this content.

Is this the most efficient code or can it be cleaned up a bit?

[watersev]

hi Gti182, option

Please Login or Register  to view this content.

[JOHN H. DAVIS]

FWIW:

Please Login or Register  to view this content.

[Gti182]

thanks for the input much appreciated.