dcsimg
CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: [RESOLVED] generating automatic col width in excel sheet using vb

Threaded View

  1. #1
    Join Date
    Dec 2008
    Location
    Step Into(F11)
    Posts
    465

    [RESOLVED] generating automatic col width in excel sheet using vb

    i simple want sheet needs to be autoadjust in excel sheet.and the column does not go beyond the another sheet .can anybody tell me ?How should i do it ?tHX in advance.
    Code:
    i = 0
                 For Each adofields In rssales.Fields
                    osheet.Range("A1").Offset(0, i).Value = UCase(adofields.Name)
                    osheet.Range("A1:M1").Font.Bold = True
                    osheet.Cells(r, c).ColumnWidth = y
                    i = i + 1
                Next
    Last edited by firoz.raj; May 24th, 2011 at 12:37 PM.

Posting Permissions

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


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)