ActiveWorksheet.Sections(1) does not work
 

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.

ActiveWorksheet.Sections(1) does not work
 

..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.