Function used to convert column alpha to numeric
Author: michael@excelexperts.co.uk
Function mycollong(mycol As String) As Long If mycol <> vbNullString Then mycollong = Cells(1, mycol).Column Else mycollong = 0 End If End Function
Function used to convert column alpha to numeric
Author: michael@excelexperts.co.uk
Function mycollong(mycol As String) As Long If mycol <> vbNullString Then mycollong = Cells(1, mycol).Column Else mycollong = 0 End If End Function