 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / November 2006in Excel, how to put gridline every ten rows
How can I set up the procedure (formatting, macro, whatever) to place a gridline every ten rows on my spreadsheets? Or, how can I get it to put a gridline at every TOTAL line, when I apply subtotals? I have EXCEL 97. try this? Sub insertline() For Each c In Range("a2:a100") If UCase(c) = "TOTAL" Then With c.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With End If Next c End Sub  SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > How can I set up the procedure (formatting, macro, whatever) to place a > gridline every ten rows on my spreadsheets? Or, how can I get it to put a > gridline at every TOTAL line, when I apply subtotals? I have EXCEL 97. I could not get what you sent to work, but that is probalby me rather than Excel. So I asked a couple others at work to look at it. After a few versions based on what you gave me, this is what we came up with to put a line every ten rows. Sub insertline() Dim x As Long For Each c In Rows x = x + 1 If x Mod 10 = 0 Then With c.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With End If Next c End Sub Thank you so much. > try this? > Sub insertline() [quoted text clipped - 12 lines] > > gridline every ten rows on my spreadsheets? Or, how can I get it to put a > > gridline at every TOTAL line, when I apply subtotals? I have EXCEL 97. What I sent was tested for any cell in col A that said Total or TOTAL or total. What you sent will put a line every 10 rows to the bottom of the workbook causing BLOAT. BAD!! SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com >I could not get what you sent to work, but that is probalby me rather than > Excel. So I asked a couple others at work to look at it. After a few [quoted text clipped - 34 lines] >> > put a >> > gridline at every TOTAL line, when I apply subtotals? I have EXCEL 97. Yes it did exactly that. But I can deal with that, some of my spreadsheets are over 35000 rows, so it is ok. And it does put the gridline across the entire line, rather than in just one column. So all is well. Again thank you for your help. > What I sent was tested for any cell in col A that said Total or TOTAL or > total. [quoted text clipped - 38 lines] > >> > put a > >> > gridline at every TOTAL line, when I apply subtotals? I have EXCEL 97. glad you are happy SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > Yes it did exactly that. But I can deal with that, some of my > spreadsheets [quoted text clipped - 48 lines] >> >> > gridline at every TOTAL line, when I apply subtotals? I have EXCEL >> >> > 97. You could add the gridlines with conditional formatting: Turn off the gridlines (Tools>Options, View tab) Select all the cells on the worksheet Choose Format>Conditional Formatting From the first dropdown, choose Formula Is In the formula box, type: =MOD(ROW(),10)=0 Click the Format button On the Borders tab, add a light grey bottom border Click OK, click OK > How can I set up the procedure (formatting, macro, whatever) to place a > gridline every ten rows on my spreadsheets? Or, how can I get it to put a > gridline at every TOTAL line, when I apply subtotals? I have EXCEL 97. SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html Debra, As usual, a great solution without creating file bloat. SignatureDon Guillett SalesAid Software dguillett1@austin.rr.com > You could add the gridlines with conditional formatting: > [quoted text clipped - 10 lines] >> gridline every ten rows on my spreadsheets? Or, how can I get it to put >> a gridline at every TOTAL line, when I apply subtotals? I have EXCEL 97. Thanks Don! > Debra, As usual, a great solution without creating file bloat. SignatureDebra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.