datastudent
Board Regular
- Joined
- Sep 7, 2021
- Messages
- 87
- Office Version
- 365
- Platform
- Windows
Hi,
I have this data where a circle is used to identify yes or no. In regular excel formula I can copy ang paste the image inside the formula but in VBA the image is not recognized. If its not possible, please give me suggestions on how I can work around it. Thank you!
In here the circle image turn into a question mark.
Range("L2").FormulaR1C1 = "=IF(RC[-4]=""?"",""N"",""Y"")"
I have this data where a circle is used to identify yes or no. In regular excel formula I can copy ang paste the image inside the formula but in VBA the image is not recognized. If its not possible, please give me suggestions on how I can work around it. Thank you!
In here the circle image turn into a question mark.
Range("L2").FormulaR1C1 = "=IF(RC[-4]=""?"",""N"",""Y"")"
Template_v1.xlsm | |||||||
---|---|---|---|---|---|---|---|
H | I | J | K | L | |||
1 | EMS | Portability | |||||
2 | ○ | ○ | N | ||||
3 | ● | ● | |||||
iBASIS_IIS |
Cell Formulas | ||
---|---|---|
Range | Formula | |
L2 | L2 | =IF(H2="○","N","Y") |