clemons171
New Member
- Joined
- Aug 10, 2016
- Messages
- 25
I would like to do the following in VBA:
Have any cell within a range of cells to return a formula in the cell if the cell is blank.
Example:
1. If Cell A1 is Blank then Cell A1 returns this formula "=IF(H24="N",$F24," ")"
2. If I input data into Cell A1, it will do nothing...the data I input remains.
3. However, if a couple days later I go back in and delete that data in Cell A1, then the formula "=IF(H24="N",$F24," ")" is returned back to Cell A1.
If somebody could help me with this that would be wonderful!
Have any cell within a range of cells to return a formula in the cell if the cell is blank.
Example:
1. If Cell A1 is Blank then Cell A1 returns this formula "=IF(H24="N",$F24," ")"
2. If I input data into Cell A1, it will do nothing...the data I input remains.
3. However, if a couple days later I go back in and delete that data in Cell A1, then the formula "=IF(H24="N",$F24," ")" is returned back to Cell A1.
If somebody could help me with this that would be wonderful!