Results 1 to 6 of 6

Transposing an Array

Threaded View

  1. #1
    Forum Contributor
    Join Date
    03-22-2012
    Location
    OR, USA
    MS-Off Ver
    Excel 14/2010
    Posts
    273

    Transposing an Array

        Set inp_form = ActiveWorkbook.Worksheets("Sheet 1")
        For i = 1 To iCountBox
            cntrng = 12 + i
            inp_form.Range("A" & cntrng).Value = i
            inp_form.Range("B" & cntrng).Value = revcode(i)
            inp_form.Range("D" & cntrng).Value = hcpc(i)
            inp_form.Range("E" & cntrng).Value = modifier(i)
            inp_form.Range("F" & cntrng).Value = iDate(i)
            inp_form.Range("G" & cntrng).Value = unit(i)
            inp_form.Range("H" & cntrng).Value = charges(i)
        Next
    Looking to pass an array into the cells using code similar to this:

        With inp_form.Range("K13:L13").Resize(iCountBox)
            .Value = Application.Transpose(cpt)
            .Sort .Resize(, 1).Offset(, 1), xlDescending, , , , , , xlNo
        End With
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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