Most valuable professional
  • Hot Topics

Excel Excel VBA to draw border on single column

Hi, Would anyone have any code to draw a border around the used range of a single column? I have a vlookup which runs in a column adjacent to a PivotTable. I have code to recreate the border around the table each time it's refreshed but I need some code to also draw a border around this additional column. Obviously this border is going to need to change dynamically as and when the table is refreshed. Also, would any code need to go into the PivotTableupdate event or just a worksheet change event? Cheers

This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of May 28, 2015.

For more resources for Microsoft Excel:

This article includes the following tags:

  • Excel
  • Microsoft Excel