excel Excel Transpose Macro When u call TransposeRangea1h1Value then u get transposed 2D Variant Array with dimensions 1 to 8 1…