VBA to apply border lines to pivot table

[Balajibenz]

Hi All,

I am doing an automation where I am creating multiple Pivots through a loop and pivot table is assigned to "pt".

Can someone help me with creating border lines as below and center align the data from "Column Labels". recording manually doesn't work as pivot table position might change for every iteration. Thank you in adavance.

Timesheet Data_Oct'20.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
16	Quarter: Q3
17	ADM	(Multiple Items)
18
19		Column Labels
20		AD			AM			Others			Total Jul'20	Total Aug'20	Total Sep'20
21	Row Labels	Jul'20	Aug'20	Sep'20	Jul'20	Aug'20	Sep'20	Jul'20	Aug'20	Sep'20
22	CSG	11481	10880	12430	7355	6487	6810	1455	1394	1731	20290	18760	20970
23	NS	4364	3697	3890	756	744	788	579	499	687	5699	4940	5364
24	VBG	44478	38852	40953	5304	5353	7404	1897	1462	1384	51678	45667	49741
25	VCG	12904	12067	11119	8437	7782	7776	1493	1194	1561	22833	21043	20455
26	Grand Total	73226	65495	68391	21851	20365	22777	5423	4548	5362	100500	90409	96529
Offshore FTE Efforts