kpmsivaprakasam2003
New Member
- Joined
- Jan 28, 2020
- Messages
- 9
- Office Version
- 365
- 2019
- 2016
- 2013
- 2011
- 2010
- 2007
- Platform
- Windows
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())
VBA:
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 for Advance
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())
VBA:
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 for Advance