border line

Hello Guys, I have workbook with Sheets 1 to 10. For each sheet, I need to find the last row, delete the excess vertical lines below it (just CTRL+DELETE). Below the last row, I need to add a vertical border by just copying the border that can be found on A3-AC3 across all sheets. Thanks in...

I have created a survey in an Excel file. Some of my cells have a light blue border around them and I do not know why. I am trying to create column graphs but the only option Excel gives me is clustered bar. I do not know if the blue border is causing this. How can I remove the blue borders?

hello I have problem on on making insidervertical border on top of insidehorizontal border. it seems that the crossing point of cell border always use the insidervertical border. how do I switch crossing point of cell border to insidehorizontal border?

I used this code in the past to draw borders based upon the NSN Stock # content of COL C. However, I've got a different file where the NSN is in COL A. I thought it was as easy as adjusting the COL reference of C to A but that's not working. I think it has something to do with the "+1"... This...

Hi Excel 2007 For Application.ThisCell.Borders.LineStyle = What are my = options?

I have the following macro, which applies a line where the text "Change" appears in column EE, and an ID number in column EF. It is fine if the "Change" text has more than a 3 row gap but if the text is in the row beneath it does not apply the line, or apply on the 2nd occurance. What am I doing...