Remove Borders in VBA

**dadrew** · 09-06-2012, 11:29 AM

I need to remove all borders on a number of worksheets using VBA. At present I can clear the data but not the borders. My code is :

Please Login or Register  to view this content.

**mike7952** · 09-06-2012, 11:43 AM

Try this

Please Login or Register  to view this content.

**dadrew** · 09-06-2012, 11:54 AM

Originally Posted by mike7952

Try this

Please Login or Register  to view this content.

Mike its the borders on the other six worksheets that Ineed to clear

**mike7952** · 09-06-2012, 12:24 PM

How bout this

Please Login or Register  to view this content.

Re: Remove Borders in VBA