Excel prob...wraptext

Results 1 to 2 of 2

Thread: Excel prob...wraptext

  1. #1
    Lynn Maharet Guest

    Default Excel prob...wraptext

    Hi all,<BR><BR>I&#039m doing export to excel..there&#039s this database field, remarks which contains a lot of words.<BR><BR>It seems that the cell is unable to accomodate all the text and return a #value inside the cell.<BR> I&#039ve tried below but it doesn&#039t works.<BR>xlWorksheet.Columns(41).WrapText=true<BR ><BR>Pls help ...thanks..;)

  2. #2
    KPW Guest

    Default RE: Excel prob...wraptext

    Hi,<BR><BR>Do you have Microsoft Excel? If so, look in the help file for Excel. You will see that the WrapText method applies to the Range object and the Selection object.<BR><BR>So, it looks like what you need to do is select a range of cells, then do a Selection.WrapText.<BR><BR>HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts