thanks david,

You have given me another option which I did not think of - Screen print-
which is exacly what i require. I think i over complicated things with
macro's etc.

regards

Brian


David McRitchie wrote:
From the question:
Select the area, File Print, selection

Or for a screen image Print Screen,
paste into word.

You kind of lost me visible on the screen without scrolling

From the Title:
File, Page Setup..., Sheet
Rows to repeat at top $1:$1
Columns to repeat at left $A:$A

for more information
http://www.mvps.org/dmcritchie/excel/freeze.htm

Hi
Wonder if anyone can help with this, have looked in previous threads but to
[quoted text clipped - 12 lines]

regards

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1