View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
 
Posts: n/a
Default condense code for gridelines


SITCFanTN wrote:
Is there a way to shorten this code a bit. I recorded this macro and just
feel there is a way to condense it, I'm just not sure how. All I'm trying to
do is add grid lines to my sheet. This macro formats about 2 dozen pages so
the less code the better. Thanks



Hi SITCFanTN

Try:

Columns("A:H").Borders.LineStyle = xlContinuous


Regards

Steve