boarders

I would appreciate assistance with VBA code that would eliminate the vertical black boarders that I show outlined in red in the following image. I am trying to write code that would use the words in column A, “ADD”, “REMOVE”, “KEEP – Paid Advertisers” as the text that would indicate the...

I am trying to add boarders to a workbook and it works on all cells bar D47 amd D49 where the right gridlines have disappeared on the workbook. No other gridlines have disappeared. I have inserted a column, deleted column D and hidden the column but it remains in column D or if I hide the...

hello, I have a complex document that is used for creating training documents/work instructions. Each step is outlined by thick boarder. there are some borders within the step but I would like for the final row on the page to have a thick bottom boarder every time on every page to complete the...

Hi all, I have a macro I created to add boarders around a table shown below. The last line BorderAround Weight:=xlThick makes the last cell of the worksheet one cell below the last one actually used. I cannot clear this. of I change it to BorderAround Weight:=xlThin it works fine but the...

hi why I can not insert a vertical boarder that will divide a cell vertically or inserting a horizontal boarder that will divide a cell horizontally. Both option are available when I go to Boarder-->more boarders. I can insert any other boarders except these 2. Why I can not and why they are...

Hi Everyone, I have a sheet with loads of areas all created by someone else who did not see the importance of merging cells, So I have boarders that I cant simply change the colour of as it takes ages. I need a macro that can change all existing boarders either on active sheet or in a...