Results 1 to 2 of 2

Thread: How to wrap text from excel spreadsheet by VB.

  1. Jul 4th, 2003, 01:31 AM #1
    taboty
    taboty is offline

    Thread Starter
    New Member
    Join Date
    Jul 2003
    Posts
    1

    Unhappy How to wrap text from excel spreadsheet by VB.

    I want to use multiline of spreadsheet in Vb but i try Chr(13) + Chr(10) and


    Selection.ColumnWidth = 30
    With Selection
    .HorizontalAlignment = xlGeneral
    .VerticalAlignment = xlBottom
    .WrapText = True '!!!!!!!!!!!!!!!!!!!!!
    .Orientation = 0
    End Width

    it not work because spreadsheet is not have property "WrapText".
    Any idea ???
    Reply With Quote Reply With Quote
  2. Jul 4th, 2003, 04:46 AM #2
    JordanChris
    JordanChris is offline
    Frenzied Member
    Join Date
    Jan 2001
    Location
    Newbury, UK
    Posts
    1,878
    Start Macro recording.
    Do what you want to do manually
    Stop macro recording
    Edit the macro and see how to do it.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width