Max Value Answer In A Range To A Single Cell VBA

[rmccain]

Hello to all and thankyou for reading this !

My issue;

1. I am trying to find a max value in a dynamic range. I think I have the code correct below.

2. What I do not have correct is the code for placing the answer of the max value in a dynamic range into the single cell "D2"

Kindest Regards To All !

Please Login or Register  to view this content.

[Andy Pope]

Please Login or Register  to view this content.

[rmccain]

Ha, it works thankyou very much but I do have a problem

I am using decimal places and it reads the data incorrectly do you know of the code to get around this ?

Thankyou Kindly

[Andy Pope]

it should not make any difference whether the values are integer or floating point.

You would need to post example file to illustrate what you think is not working

[rmccain]

Actually it does work correctly. I was tired and looking at the wrong column.

Thankyou again for your help !