VeryForgetful
Board Regular
- Joined
- Mar 1, 2015
- Messages
- 242
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
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