VBA - Excel PageSetup property

[Richard Veber]

I am manipulating Excel workbooks in VBA from Access, and
all has been well for about a year. On some worksheets
however a limit is being met with worksheets.pagesetup
object, of the no of chars or complexity or both.
the symptom is that VBA gives an error on attempting to
set the worksheets.pagesetup.centerheader property

sometimes a workaround is to delete existing data and retry

has anyone found a way around this apparent limitation?

I am posting this to the relevant Excel newsgroup as well

Thanks
Richard