add a footer to excel through VB code
 

Is it possible to add a footer to an excel doc. through VB code?
Any help will be highly appreciated.

Thank U all in advance,
Tej

add a footer to excel through VB code
 

Hi Tej

See below:

With ActiveSheet.PageSetup
.LeftFooter = "&BClee Hill Electrics Confidential&B"
.CenterFooter = "&D"
.RightFooter = "Page &P "
End With

With tasks like this use the macro recorder, then delete the extra items
which are not required.

--
Tony Green


" wrote:

Is it possible to add a footer to an excel doc. through VB code?
Any help will be highly appreciated.

Thank U all in advance,
Tej