View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Sandy[_3_] Sandy[_3_] is offline
external usenet poster
 
Posts: 43
Default Code to put contents of A1 and B1 in header

Dear Tom:

Thanks for your reply. I mean that I have text in Cell A1
and text in Cell A2. I would like that text to display in
the Header of each printed sheet.

Sandy

-----Original Message-----
If you mean in the gray labels, no. You can make them

(A1 and B1) look
similar to labels using formatting and hide the labels,

but I am not sure of
the utility of that.

Regards,
Tom Ogilvy

Sandy wrote in message
...
I would like to put the contents of A1 and B1 into the
header. A1 and B1 are not names of columns.

Is there a way to do this? I came up with zip when
searching Help.

Sandy



.