Repeating Columns - Formatting only on First Page

[cmore]

Hi I have set of data and have borders around column A and Column A is repeated if there are addl. pages. The problem is I only want to repeat the borders on the 1st instance of the column rather than all of its subsequent repeats?

Is this possible?

[TMS]

Wouldn't have thought so.

Regards, TMS

[cmore]

I haven't been able to come up with anything, other than maybe if I go about printing it and replacing the first page through code, but that seems like it would be really cumbersome.

[TMS]

Record a macro while you print page 1, clear the borders, and then print the rest of the pages.

Please Login or Register  to view this content.

Regards, TMS

[cmore]

Nice, thanks I have a little wiggle in there that makes it slightly more complicated, I'm going to try not to be sick and see if I can put some code together and post in a bit.