Microsoft Office Forums - View Single Post - [Solved] repeat header rows after VBA paste

Thread: [Solved] repeat header rows after VBA paste

View Single Post

Old

08-20-2018, 05:50 AM

Homegrownandy Homegrownandy is offline

Homegrownandy is offline

Homegrownandy uses Windows 10

Windows 10 Homegrownandy uses Office 2016

Homegrownandy uses Office 2016

Office 2016

Novice

The original poster

Join Date: Jul 2018

Posts: 14

Homegrownandy is on a distinguished road

Default

Paul,

I've took out the line:
.Tables(1).Rows(1).HeadingFormat = True
It now works perfect with header repeating enabled. Clearly your changes did something that it likes!

Thanks a lot.

Reply With Quote