skorpionkz
Well-known Member
- Joined
- Oct 1, 2013
- Messages
- 1,171
- Office Version
- 2016
Hi guys,
I have range with data, that I need to validate. Some of the columns have formula in it. Is there any way to pass formula itself (not result) to an array, and then array paste back to the range.
There is 2 reason why I am doing this.
1st. it is faster to loop through data to do analises.
2nd. In some cases when I receiving file, guys who creating them copying and pasting the data. sometimes they using lookup with IFERROR(....,""). The "" causing the other formulas result with the error. Adding to array and pasting back fix this problem
Thank you.
I have range with data, that I need to validate. Some of the columns have formula in it. Is there any way to pass formula itself (not result) to an array, and then array paste back to the range.
There is 2 reason why I am doing this.
1st. it is faster to loop through data to do analises.
2nd. In some cases when I receiving file, guys who creating them copying and pasting the data. sometimes they using lookup with IFERROR(....,""). The "" causing the other formulas result with the error. Adding to array and pasting back fix this problem
Thank you.
Last edited: