Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Repeat Column Headers...

Status
Not open for further replies.
VisualGuy

VisualGuy

Programmer
May 27, 2003
162
US
I know about the .PageSetup.LeftHeader etc... However, I want to repeat a range of column headings for each page. Isn't there a way to do this through VBA?
 
Sort by date Sort by votes




Hi,

File > Page Setup - Sheet Tab: Print titles--Rows to repeat at top

User your macro recorder.

Skip,

[glasses] When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large[tongue]
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

IcarusHallsorts
  • Locked
  • Question
I have a column of data in Column A
Replies
3
Views
399
Andrzejek
Andrzejek
MattGreer
  • Locked
  • Question
VBA Code Deleting a Column instead of Rows...
Replies
6
Views
240
SkipVought
S
mohamadmh
  • Locked
  • Question
Loop through column a tricky one
Replies
12
Views
312
Andrzejek
Andrzejek
corbinap
  • Locked
  • Question
Do loop to find text and add verbiage if found in another column
Replies
2
Views
159
corbinap
corbinap
EliseFreedman
  • Locked
  • Question
Running Code for every value in a column 1
Replies
4
Views
168
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top