ActiveWorksheet.Sections(1) does not work

  • Thread starter Thread starter Jess
  • Start date Start date
J

Jess

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
 
Back
Top