I have just started learning VBA. I want to find the maximum value from absolute values of cells and then format that cell by bolding it. I am able to find the max value of the absolute values of cells in the row by the code:
Maxx1= Application.WorksheetFunction.Max((Abs(Range("B11"))), (Abs(Range("C11"))), (Abs(Range("D11"))))...
However, if I do maxx1.select
or
maxx1.font.fontstyle = "Bold",
it gives an error "Object required".
Thus I am not able to format it.
Any inputs on this would be greatly appreciated.
Maxx1= Application.WorksheetFunction.Max((Abs(Range("B11"))), (Abs(Range("C11"))), (Abs(Range("D11"))))...
However, if I do maxx1.select
or
maxx1.font.fontstyle = "Bold",
it gives an error "Object required".
Thus I am not able to format it.
Any inputs on this would be greatly appreciated.