Hi there,
How can I use Select Case in VBA for a cell where the value is calculated based on a formula?
In cell A1 in Sheet 2, I have =IF(ISBLANK('Sheet 1'!A1),"","Check") and I need the Select Case in VBA to populate cell N in Sheet 2 with "Check" if A1 in Sheet 2 gets "Check" and if A1 in Sheet 2 gets "" from the formula in it, then N in Sheet 2 should also be null.
Thanks.
How can I use Select Case in VBA for a cell where the value is calculated based on a formula?
In cell A1 in Sheet 2, I have =IF(ISBLANK('Sheet 1'!A1),"","Check") and I need the Select Case in VBA to populate cell N in Sheet 2 with "Check" if A1 in Sheet 2 gets "Check" and if A1 in Sheet 2 gets "" from the formula in it, then N in Sheet 2 should also be null.
Thanks.