Hello all,
I'm on the look-out for something which I think will be relatively easy. I'm looking for a macro/VBA-code that
I have Excels built based on SmartView with HsGetValue formulas. However, when I mail this to people that don't have the SmartView set-up, the cells with HsGetValue default to N/A. I want to transform those to their values. However, I want to keep normal formulas (like totals, index/match, ...) that don't have HsGetValue so the user can see how the document is built up.
Whoever that can help me, would save me a bunch of work.
I'm on the look-out for something which I think will be relatively easy. I'm looking for a macro/VBA-code that
- will cycle through every sheet of a workbook
- which simply replaces cells that have a formula that includes a HsGetValue with their value (basically as if you would be copy/paste values the cell).
I have Excels built based on SmartView with HsGetValue formulas. However, when I mail this to people that don't have the SmartView set-up, the cells with HsGetValue default to N/A. I want to transform those to their values. However, I want to keep normal formulas (like totals, index/match, ...) that don't have HsGetValue so the user can see how the document is built up.
Whoever that can help me, would save me a bunch of work.