View Single Post
  #7   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

Thanks, Gord!

Sandy
-----Original Message-----
Thanks Tom, for the heads up.

I got no error, but the code also did not place the cell

contents in the
Header as I thought.

Gord

On Sun, 17 Aug 2003 16:56:37 -0400, "Tom Ogilvy"

wrote:


.Range("A1:B2").Text gives an error

.Range("A1").Text & " " & .Range("B1").Text

maybe what you meant.


.