I have a sub in a workhseet where I have typed in the following:

With ActiveWorksheet.Sections(1) 'excel triggers an error at this line
.Footers(wdHeaderFooterPrimary).PageNumbers.Add
End With

Excel is triggering an error in the first line: Object required.

What is going on? This sample was obtained from the excel help. Microsoft
Excel Object 12 library is enabled.

..Section is in MS word. For excel

ActiveSheet.PageSetup.LeftFooter = ""

For center and right ; CenterFooter OR RightFooter

If this post helps click Yes
---------------
Jacob Skaria


"Jess" wrote:

> I have a sub in a workhseet where I have typed in the following:
>
> With ActiveWorksheet.Sections(1) 'excel triggers an error at this line
> .Footers(wdHeaderFooterPrimary).PageNumbers.Add
> End With
>
> Excel is triggering an error in the first line: Object required.
>
> What is going on? This sample was obtained from the excel help. Microsoft
> Excel Object 12 library is enabled.
>