Reading Header information into a cell

grasshoffer

New Member
Joined
Mar 21, 2002
Messages
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.<marquee behavior="alternate">.</marquee>
_____________
'Hey, you deal with the particulars, I'll deal with the specifics.'
sayings and fragments, xxii
ban-chan<marquee behavior="alternate">.</marquee>
This message was edited by grasshoffer on 2002-03-22 13:20
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
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
 
Upvote 0
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?
 
Upvote 0

Forum statistics

Threads
1,213,549
Messages
6,114,264
Members
448,558
Latest member
aivin

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top