MrExcel forum users,
I am using the below VBA formula in an attempt to find the largest value of a cell range J3:J42.
However, the data in the J3:J42 range of cells has been created using a MID formula that feeds from the adjacent column that contains a string of text and numbers(the MID formula results in only the number portion being displayed in cells J3:J42).
I know the Application.WorksheetFunction.Max works when used against a column containing numerals. Is there a way to adjust this line to work correctly against a column containing formulas by reading the value of each cell?
Sub LargestValue()
'Finds Largest Number In The "Netbook Friendly Number - Number Only" Column Of The Netbook Number Worksheets
Dim WS
Call DefineRanges
WS = ActiveSheet.Name
MaxNum = Application.WorksheetFunction.Max(Worksheets(WS).Range(NetbookCartWSSortByCol))
End Sub
Thanks much!
-Matt-
I am using the below VBA formula in an attempt to find the largest value of a cell range J3:J42.
However, the data in the J3:J42 range of cells has been created using a MID formula that feeds from the adjacent column that contains a string of text and numbers(the MID formula results in only the number portion being displayed in cells J3:J42).
I know the Application.WorksheetFunction.Max works when used against a column containing numerals. Is there a way to adjust this line to work correctly against a column containing formulas by reading the value of each cell?
Sub LargestValue()
'Finds Largest Number In The "Netbook Friendly Number - Number Only" Column Of The Netbook Number Worksheets
Dim WS
Call DefineRanges
WS = ActiveSheet.Name
MaxNum = Application.WorksheetFunction.Max(Worksheets(WS).Range(NetbookCartWSSortByCol))
End Sub
Thanks much!
-Matt-
