Reading Header information into a cell

grasshoffer · Mar 22nd, 2002, 02:15 PM

Is it possible to read header information into a cell?
For example, 5 sheets, each with a date. I want to be able to read the date off of each one into a cell on a 6th sheet..
_____________
'Hey, you deal with the particulars, I'll deal with the specifics.'
sayings and fragments, xxii
ban-chan.

[ This Message was edited by: grasshoffer on 2002-03-22 13:20 ]

Al Chara · Mar 22nd, 2002, 04:04 PM

How about the following code:

Dim i As Integer
For Each ws In Worksheets
i = i + 1
If ws.Name <> Worksheets(6).Name Then Worksheets(6).Range("a" & i).Value = Worksheets(i).PageSetup.CenterHeader
Next ws

It places the value of the center header of worksheets 1-5 into cells in column A starting with A1 of worksheet 6

grasshoffer · Mar 23rd, 2002, 11:34 AM

Great help! This will work quite nicely. I know Excel pretty well, but not much programming beyond cell formulas. What sort of resources do you use [or did you use] to learn the programming of Excel, specifically. Any resource suggestions?

Juan Pablo González · Mar 23rd, 2002, 02:22 PM

This board in particular.
Online help
Particular cases.
Practice
Practice
Practice

Mar 22nd, 2002, 04:04 PM	#2
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	How about the following code: Dim i As Integer For Each ws In Worksheets i = i + 1 If ws.Name <> Worksheets(6).Name Then Worksheets(6).Range("a" & i).Value = Worksheets(i).PageSetup.CenterHeader Next ws It places the value of the center header of worksheets 1-5 into cells in column A starting with A1 of worksheet 6 __________________ Kind regards, Al Chara

Mar 23rd, 2002, 02:22 PM	#4
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	This board in particular. Online help Particular cases. Practice Practice Practice __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 22nd, 2002, 02:15 PM	#1
grasshoffer New Member Join Date: Mar 2002 Location: Texas Posts: 2	Is it possible to read header information into a cell? For example, 5 sheets, each with a date. I want to be able to read the date off of each one into a cell on a 6th sheet.. _____________ 'Hey, you deal with the particulars, I'll deal with the specifics.' sayings and fragments, xxii ban-chan. [ This Message was edited by: grasshoffer on 2002-03-22 13:20 ]

Mar 23rd, 2002, 11:34 AM	#3
grasshoffer New Member Join Date: Mar 2002 Location: Texas Posts: 2	Great help! This will work quite nicely. I know Excel pretty well, but not much programming beyond cell formulas. What sort of resources do you use [or did you use] to learn the programming of Excel, specifically. Any resource suggestions?