border code

  1. S

    VBA to select range of cells down to bottom border - ?????

    Hey, so I will make this fast. I am looking for a way to select a range of cells, starting with A17, down column A, to where a bottom double line border is. There are no other bottom borders in the range. The range can vary, i.e. A17:A46; A17:A2345837, etc etc. All of the range's cells may...
    • spydey
    • Thread
    • border code cells excel vba 2013 range range selection
    • Replies: 4
    • Forum: Excel Questions
  2. C

    VBA code to add thick border around group of rows containing a bolded cell.

    Once again I need your help. I am looking for a code to find rows that have atleast one bolded cell then place a thick border around that row and if there are consecutive rows containing bolded cells add a thick border around group of cells. the range is A12 to column R and the bottom row used...
  3. J

    Automatically adding border line after a change in value in a column

    I've looked at a couple other posts, but haven't been able to make this work for my situation using VBA. I want a thin border along the bottom of the cells in columns A:K whenever the value in column A changes. So, _A___B____C______________K__ 234 234 245 245 245 267 299 299 Becomes...
  4. J

    VBA code to add a border

    The below code adds a line to the next blank row. I would like to add a border to this row that the values are going into. Columns "A:G" Private Sub CMD_Add_Click() Dim rNextCl As Range Set rNextCl = Worksheets("Main").Cells(Rows.Count, 2).End(xlUp).Offset(2, 0)...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top