MODERATOR NOTICE: This topic has also been posted on other sites and may already have an answer elsewhere. Please take this into consideration when answering this question
IF and Max Formula through VBA
I am using Excel 2013
I have applied the VBA formula but not return the results
Below formula:
=IF(ISNUMBER(I6),IF(VALUE(I6)=$L$6,MAX($H$6:$H$79),NA()),NA())…
stackoverflow.com
IF and Max Formula through VBA
Hi, I am using Excel 2013
I have applied the VBA formula but not return the results
Below formula:…
chandoo.org
IF and Max Formula through VBA
Hi, I am using Excel 2013
I have applied the VBA formula but not return the results
Below formula:…
www.mrexcel.com
Hi, I am using Excel 2013
I have applied the VBA formula but not return the results 
Below formula:
=IF(ISNUMBER(I6),IF(VALUE(I6)=$L$6,MAX($H$6:$H$79),NA()),NA())
Code
Dim MyRange As Range
Set MyRange = Range("D5").Offset(1, 1 + 3).Resize(m + 1, 1)
Range("D5").Offset(1, 1 + 6).Formula = "=IF(ISNUMBER(" & Range("D5").Offset(1, 1 + 4).Address(0, 0) & ",IF(VALUE(" & Range("D5").Offset(1, 1 + 4).Address(0, 0) & "=" & Range("D5").Offset(1, 3 + 5).Address(1, 1) & ",MAX(" & MyRange.Address & "),NA()),NA())"Thanks in advance
