Re: $$Excel-Macros$$ Macro to add bottom border to cells in range

2010-11-05 Thread Paul Schreiner
aul - Original Message > From: Kurt > To: MS EXCEL AND VBA MACROS > Sent: Fri, November 5, 2010 10:28:46 AM > Subject: $$Excel-Macros$$ Macro to add bottom border to cells in range > > I have several dynamic named ranges that span multiple worksheets. The > range

$$Excel-Macros$$ Macro to add bottom border to cells in range

2010-11-05 Thread Kurt
I have several dynamic named ranges that span multiple worksheets. The ranges are named Sheet1Data, Sheet2Data ... up to Sheet4Data. I need to create a macro that applies a bottom border to the last row in each range. I've taken some code that loops through the *cells* in each range (Dim c As Rang