borders

I am using code to apply basic borders around all used cells in a worksheet. Perfectly, this applies borders to the anticipated range. I use the same range to set the print area. I'd like to modify the macro to modify this range so as to set the print area AND apply borders to all cells...

OK for some reason while using a bunch of named ranges to clear out the data the borders get changed to the heavy border. So after a bunch of playing around with it I see that if I run the sub with nothing in the cells to clear it doesn't change any formatting. But I type something in the top...

I'm trying to customize my toolbar with a button that sets the borders of a cell(s) to thin/grey. To start, I use Format/Cell to set cell border color to grey, thickness to thin, click all the borders. Then.. View Toolbars Customize Commands Format And dragging the Border button to my toolbar...

I am needing to add the right border and last row bottom border for a variable set of data. The columns will always have data in columns "A" through "I". Starting with row 27 and ending with a variable row. Anything would be great. Thank you in advance!

I have written code to insert borders on all sheets from row 9 up to the row before where total appears in Col A (could be total repairs, total expenses etc) I need the borders to be from Col a to the last Column Containing Text in Row 9. Your assistance is much appreciated Sub...

Hello all How can I select a range with an expanding Last Row, I have tried with the code below but it is not working Once the range is selected it calls two macro for borders and colours LR = Range("C" & Rows.Count).End(xlUp).Row Range("C16:AA" & LR).select AddOutsideBorders Colour1

Will post again

Hi Excel masters, I am trying to make a macro, How am I going to add rows like for example Column C = Schedule lines If C=3 it will automatically add 1 row If C = 4 it should add 2 row up until 10 some people saying it should be done backwards but i dont know how. and also putting borders...

Hi all, I found this code & it works, but I need to alter it so that only the top, bottom, and internal horizontal are bordered (no internal verticals). My range is Col A-F, variable number of rows, do not border the header row A1:F1. Help? Sub TheWall() Application.ScreenUpdating = False...

I have a workbook in which I will import the current month's worksheet and run a code to compare with the previous month and return the differences onto a third worksheet. I was using the following code with no issues, then suddenly out of nowhere I get a "Runtime error '1004...

I don't want the borders to show on my Active X ComboBox in Excel 2013. I only want the drop down arrow and box contents to be visible. How do I get rid of or clear the borders?

Hi All, I currently have a worksheet called “Summary.” It has values in columns A to J. I want to add borders to every single cell that has data in it (in that worksheet only). No data, no border. Etc. I’m already running several macros in the entire workbook so conditional formatting will not...

Hello, Does anyone know how I could use conditional formatting for highlighting blank cells? Basically, I have cells with a letter X and other cells that are blank. I want to use conditional formatting to highlight the borders red if the cells are empty. For some reason it only seems to work...

I don't like the look of the default action when selecting a cell or cells which is to draw a heavy border around it/them. Can this default behavior be changed for the entire application? (as opposed to a single workbook) For example, I would like cell borders to NOT be modified from their...

I am pulling my hair out in frustration! I am trying to format a pivot table. I tried adding borders. The vertical borders seem OK, but my horizontal ones are all over the place. I am unable to see find the logic to adding them the way I want. But the worst is ... now I can't get rid of them...

Hello - I'm creating a workbook for our accounting team that starts with a QuickBooks report (sheet1), which feeds into a distribution report (sheet2) which feeds into a third report (sheet3) that will be used to import raw data back into QuickBooks. I'm having trouble syncing sheets 1 & 2 -...

Hello, How would I be able to get VBA to display borders and cell color from a selected item from my validated data list? I have some code listed here. The first part the data validation list works just fine. I am wanting to add a if statement that runs with the selection of "of Capacity". I...

Hello, I'm running into an unusual situation in Excel (v 2016 Professional Plus). Upon entering data into cells, I am noticing random borders being drawn around the cell and row. I checked for any "Customized Formatting" rules and none are enabled for the entire sheet yet this behavior still...

Out of the blue, Excel 2016 has started doing this. When I typed 1.5 and hit Enter, the entire row got the top and bottom border. When I entered a number in E2 and then deleted it, the cell got a border all around. These are phantom border. If you print-preview, they do not appear. They also...

I would like to have a vba code so as to add borders from active cell to left till first column and upwards till first row.