Results 1 to 5 of 5

Iterate through merged range

Threaded View

  1. #1
    Registered User
    Join Date
    11-20-2008
    Location
    Washington
    Posts
    16

    Iterate through merged range

    I'm trying to iterate through a range of merged cells, but each cell in the merged row is being iterated through and I want it to go from row to row.
    This what I have, but the subscript goes out of range since is looking at the cells within the merged rows.

    Public Sub PostSupers(ByRef rngSupers As Range, ByRef strarySupers() As String)
        
        Dim intSuper As Integer
        Dim Super As Range
        intSuper = 0
        For Each Super In rngSupers
    
            Super.Value = strarySupers(intSuper)
            intSuper = intSuper + 1
    
        Next Super
    
    End Sub
    Last edited by MrFoxar; 09-02-2009 at 12:35 AM. Reason: solved

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