border cell by vba

  1. R

    Create a border around a range of dynamic cells

    Hello, I have a table dependent on another table that users will input information. I am trying to make my table dynamic, meaning that I want the border to move up and down with the displayed values when it is updated by a command button. For example, from my picture I would like the border to...
  2. R

    Adding Borders with VBA

    Hello, I am trying to add a button that will edit the row under the last row with values. I am having difficulty with adding a border around Cell (SubNewRow,2). Also, if i wanted to span this border on SubNewrow from column B to M how would I write that? Thanks. Private Sub...
  3. C

    VBA Macro to Insert Rows Below ActiveCell with Formatting

    All, I have started a code that inserts n-number of rows below based on a dialog box. Now I want to format all of the rows added with all thin borders and then thick outside borders. Any help would be GREATLY appreciated as I am under a time crunch! Sub insertMultipleRows() Dim iCountRows As...
  4. N

    How to automatically bordered cell as it filled with data?

    Hello all I want to border individual cell as that cell filled with data with vba code or by condition formating. I have tried by condition formatting but its still stuck like want more knowledge:rolleyes: . please help me. Thanks in Advance.

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