I’m using the following code to copy a row of data onto itself such that all values (including formulas results) are set to fixed values. According to ‘the book’ get/setDataArray() copies numbers and strings, but doesn’t mention comments. How can I copy & paste ‘values only, plus comments’ ?. Thanks.
Range = Sheet.getCellRangeByPosition(0, lastrow-1, 75, lastrow-1)
out = Range.getDataArray()
Range.setDataArray(out)