I have received the answer on how to loop through columns to get the max length for each one. I have attached all the code and it does work. However, the first column will always return the 300 + as that is where the footnote is located, so now, how to I actually get the Max value, but the max value less than 300
Public Sub LengthCountTest()
Dim rngCell As Range
Dim intColTextLength As Integer
Dim intRowCount As Integer
Dim intColCount As Integer
Dim aryColCount() As Integer
Dim intColumns As Integer
Dim intColNumber As Integer
Dim strNextColumn As String
Dim intMax As Integer
'First set the print area to a named range
.Names.Add "ReportArea", _
"=" & Range("Print_Area").Address
intRowCount = .Range("ReportArea").Rows.Count
Debug.Print "Number of Rows: " & intRowCount
intColCount = .Range("ReportArea").Columns.Count
Debug.Print "Number of Columns: " & intColCount
ReDim aryColCount(1 To intColCount)
intColumns = 1
Do Until intColumns > intColCount
strNextColumn = WhichColumn(intColumns)
For Each rngCell In Range(strNextColumn & ":" & strNextColumn).Columns
intMax = fntMaxInCol(strNextColumn)
intColumns = intColumns + 1
Function fntMaxInCol(col As String) As Integer
'Finds the longest string in a column
Dim lngLastrow As Long
Dim i As Long
lngLastrow = Range(col & Rows.Count).End(xlUp).Row
fntMaxInCol = 0
For i = 1 To lngLastrow
If Len(Range(col & i).Value) > fntMaxInCol Then fntMaxInCol = Len(Range(col & i).Value)
Public Function WhichColumn(intColNumber As Integer) As String
'Determines which colum is next in the loop based on inter passed in
Select Case intColNumber
WhichColumn = "A"
WhichColumn = "B"
WhichColumn = "C"
WhichColumn = "D"
WhichColumn = "E"
WhichColumn = "F"