Happy Codings - Programming Code Examples

Html Css Web Design Sample Codes

CPlusPlus Programming Sample Codes

JavaScript Programming Sample Codes

C Programming Sample Codes

CSharp Programming Sample Codes

Java Programming Sample Codes

Php Programming Sample Codes

Visual Basic Programming Sample Codes

Visual Basic Programming Code Examples

Visual Basic > Applications VBA Code Examples

Transposing a 2d array

Transposing a 2d array

The code below can be used to transpose (or invert) a 2d variant array. Eg a 2d array with 2 columns and 6 rows, would become a 2d array with 6 columns and 2 rows:

'Purpose   :    Transposes a 2D array
'Inputs    :    avValues                    The array to transpose.
'Outputs   :    Returns the array transposed, or empty if an error occurs


Function Array2DTranspose(avValues As Variant) As Variant
    Dim lThisCol As Long, lThisRow As Long
    Dim lUb2 As Long, lLb2 As Long
    Dim lUb1 As Long, lLb1 As Long
    Dim avTransposed As Variant
    
    If IsArray(avValues) Then
        On Error GoTo ErrFailed
        lUb2 = UBound(avValues, 2)
        lLb2 = LBound(avValues, 2)
        lUb1 = UBound(avValues, 1)
        lLb1 = LBound(avValues, 1)
        
        ReDim avTransposed(lLb2 To lUb2, lLb1 To lUb1)
        For lThisCol = lLb1 To lUb1
            For lThisRow = lLb2 To lUb2
                avTransposed(lThisRow, lThisCol) = avValues(lThisCol, lThisRow)
            Next
        Next
    End If
    
    Array2DTranspose = avTransposed
    Exit Function

ErrFailed:
    Debug.Print err.description
    Debug.Assert False
    Array2DTranspose = Empty
    Exit Function
    Resume
End Function

Function Overriding in The C++ Language - Function overriding is a feature that allows us to have a "same function" in child class which is already present in the parent class. A child class inherits the data members and member

Count Number of non leaf nodes of a tree - C create a new node with the data from the user. Check for root node and then create it. Search for the appropriate position to insert the new node. Display and count the sum of

C Program to find determinant of a matrix - C program to read elements in a matrix and find determinant of the given matrix. The Determinant of a matrix is a special number that can be calculated from the elements of

Find Maximum between 2 Numbers using - C Program input two numbers from user and find maximum between two numbers using switch case. Input two numbers. Store it in a variable say j1 & j2. Switch expression j1 > j2

C Program to Find Sum of Array Elements - Find Sum of Array elements Using Recursive function in C language. Function declaration to find sum of array. Input size and elements in array. Recursively find the sum of elements

C Codes Displays Largest Element of Array - This C Program takes n number of elements from user and stores it in array arr[]. To find the largest element, the first two elements of array are checked and largest of these two...

C++ Sample Calculate Power of a Number - Program takes two numbers (a 'base number' and an 'exponent') and Calculates the Power. The technique works only if the exponent is a positive integer. If you need to find the power

C++ Code Solves Tower of Hanoi Problem - In The C++ program, displays the solution to the Tower of Hanoi problem using the base-2 representation of the move number with the following rules:- There is one binary digit (bit)