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

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.