Payle
05-21-2014, 03:55 AM
Hi all,
I am trying to implement an IF function in VBA that will perform a formula if the logical test is true and leave the cell blank if the logical test is false. I have used the following input but it will not work:
Range("B4:B36505").Formula = "=IF((ROW(B4)-4)<$T$5,B3+1,"")"
Is there any way to make cell blanks if the logical test of an IF function is false in VBA?
Cheers,
Michael
I am trying to implement an IF function in VBA that will perform a formula if the logical test is true and leave the cell blank if the logical test is false. I have used the following input but it will not work:
Range("B4:B36505").Formula = "=IF((ROW(B4)-4)<$T$5,B3+1,"")"
Is there any way to make cell blanks if the logical test of an IF function is false in VBA?
Cheers,
Michael