I have an array QikViewArr(1 To UBound(TmpArr, 1), 1 To 4). The data in QikViewArr is already programatically populated.
QikViewArr is dumped to a worksheet as per
Range("A3:D" & 3 + UBound(QikViewArr, 1) - 1) = QikViewArr
The Column headings on QikViewSheet are in Row 3 i.e. A3, B3, C3, and D3. Those values are programatically formatted to appear like hyperlinks i.e.
.Font.Bold = True
.Font.ColorIndex = 5 ' blue
.Font.Underline = xlUnderlineStyleSingle
I wish the user to CLICK on the Column Headings (in Row 3) and have the data on the sheet programmatically sorted in Descending order by THAT COLUMN.
Sound structured code with meaningful variable names only please ...