I don't use the CDO Interface as you do so can't speak to that.

Many other use the CDO so will jump in and give instructions.


Gord

On Tue, 27 Nov 2007 13:46:03 -0800, Soon-to-retire Teacher
wrote:

Thanks Gord, I'll try that tip.
BTW: How does a 'newbie' begin a NEW threat/questions? ...seems strange to
jump in on someone else's coat tails..

"Gord Dibben" wrote:

Either click in the dialog box and point to row1 or enter 1:1 in the dialog
box.


Gord Dibben MS Excel MVP

On Tue, 27 Nov 2007 11:51:03 -0800, Soon-to-retire Teacher <Soon-to-retire
wrote:

I have been unsucessful trying this... error message appears... "Reference is
not Valid". Here's what I do: open Excel a work sheet File Page Setup
I click 'Sheet' in the Print Titles area, I place a 1 (for the row what I
want to repeat at the top of each page in the Rows to Repeat at Top Area
click OK error message... "Reference is not Valid."

I'm probably overlook something as plain as the nose on my face. Any help
appreciated.