Results 1 to 5 of 5

Looping thru Workbooks problem

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-03-2005
    Posts
    315

    Looping thru Workbooks problem

    Can someone explain why this code generates "Object doesn't support this property or method" error?

    Sub LoopThruWkBooksWkSheets()
    Dim wb as WorkBook
    Dim ws as WorkSheet

    For Each wb In Workbooks
    For Each ws In Worksheets
    wb.ws.Cells.ColumnWidth = 3 ----> error line
    Next
    Next
    End Sub

    The idea is to loop through all open workbooks and all worksheets therein to reset the columnwidths to 3. The above code can be tweaked to work by activating each Workbook as in:

    Sub LoopThruWkBooksWkSheets()
    Dim wb as WorkBook
    Dim ws as WorkSheet

    For Each wb In Workbooks
    wb.activate
    For Each ws In Worksheets
    ws.Cells.ColumnWidth = 3
    Next
    Next
    End Sub

    ...but this is arguably not elegant even by turning off screenupdating.


    TIA

    David
    Last edited by davidm; 04-13-2006 at 01:17 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1