Ark68
Well-known Member
- Joined
- Mar 23, 2004
- Messages
- 4,564
- Office Version
- 365
- 2016
- Platform
- Windows
Code:
.Range("C6:C17").Formula = "=INDEX('[" & wb_pbef.Name & "]CORE_DATA'!L2:$L$" & drows & ",Sandbox!$D$1)"
This line of code populates the range of cells C6:c17 with the index formula forom a second source workbook. The data in column L of the source data worksheet is normally text, but often times holds nothing. (cell is empty).
For those empty cells, this formula leave a value of 0 (zero) in the destination cell.
How can I ensure that the target cell remains empty, rather than being populated with a zero when the source cell is blank?