Many Thanks for all of your suggestions. I think ultimately what I was trying
to do was too complicated for the needs of the workbook.

I have used some of what has been proposed but have also created a workround.

Thanks again for all of your help.

"Phil" wrote:

I am in need of some help regarding the creation of a simple MAX calculation
in my code.

The data is something like the following:

Col I Col J Col K Col L
12 4 7 19

How would I write a line of code that will identify that within this array
Column L has the largest figure?

Many thanks