| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Retrieve Center Header String
As part of a macro I am opening an existing workbook. That WB has a center
header in the print set up. How can I pull that center header string into the macro and assign it to a variable? Dim SHeader as String Sub GetHeader Workbooks.Open "Test.xls" sHeader= what? ........... ........ End Sub -- Ken Hudson |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Retrieve Center Header String
Assign the PageSetup.CenterHeader property for the worksheet to your
variable. -- Rick (MVP - Excel) "Ken Hudson" wrote in message ... As part of a macro I am opening an existing workbook. That WB has a center header in the print set up. How can I pull that center header string into the macro and assign it to a variable? Dim SHeader as String Sub GetHeader Workbooks.Open "Test.xls" sHeader= what? ........... ........ End Sub -- Ken Hudson |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Retrieve Center Header String
I can't get the code right to do this.
sHeader=PageSetup.CenterHeader doesn't work? -- Ken Hudson "Rick Rothstein" wrote: Assign the PageSetup.CenterHeader property for the worksheet to your variable. -- Rick (MVP - Excel) "Ken Hudson" wrote in message ... As part of a macro I am opening an existing workbook. That WB has a center header in the print set up. How can I pull that center header string into the macro and assign it to a variable? Dim SHeader as String Sub GetHeader Workbooks.Open "Test.xls" sHeader= what? ........... ........ End Sub -- Ken Hudson |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Retrieve Center Header String
orry Rick, I got it. I needed:
sHeader=ActiveSheet.PageSeetup.CenterHeader My apologies. -- Ken Hudson "Rick Rothstein" wrote: Assign the PageSetup.CenterHeader property for the worksheet to your variable. -- Rick (MVP - Excel) "Ken Hudson" wrote in message ... As part of a macro I am opening an existing workbook. That WB has a center header in the print set up. How can I pull that center header string into the macro and assign it to a variable? Dim SHeader as String Sub GetHeader Workbooks.Open "Test.xls" sHeader= what? ........... ........ End Sub -- Ken Hudson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to retrieve the value within string? | Excel Discussion (Misc queries) | |||
| How can I Left justify the center section of the print header? | Excel Programming | |||
| How do I left justify center section header | Excel Discussion (Misc queries) | |||
| Find the first Value in a Row and Retrieve the Header for That Column | Excel Discussion (Misc queries) | |||
| Named Range in Center Header | Excel Programming | |||
Linear Mode
