Hello
I am trying to find the highest value in range "d6:d13, the problem is when ever i run the code below it works perfectly on cells that doesnt have a formula, once the cell has a formula, the mx result returns as zero. I am a bit confused as to why, is it that the code is not seeing the value in the cell as a number, but as a formula, hence the resason its not calculating it?
I would like the result to show in range "a1", with the active row offset to column "c". Please help if possible
Please Login or Register to view this content.
Bookmarks