M
Microuch
I have spent much of the morning looking at various forums & threads bu
had no luck finding exactly what I need.
As you can see the code below updates the right headers for all sheet
in my workbook with the value in sheet = VBlookup, Cell B1. I hav
several sheets in the work book that I don't want updated. Is i
possible to specify which sheets the code update?
Thanks in advance
Sub CellInFooter()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.PageSetup.RightHeader = Range("VBlookup!B1").Text
Next ws
End Su
had no luck finding exactly what I need.
As you can see the code below updates the right headers for all sheet
in my workbook with the value in sheet = VBlookup, Cell B1. I hav
several sheets in the work book that I don't want updated. Is i
possible to specify which sheets the code update?
Thanks in advance
Sub CellInFooter()
Dim ws As Worksheet
For Each ws In ActiveWorkbook.Worksheets
ws.PageSetup.RightHeader = Range("VBlookup!B1").Text
Next ws
End Su