A
Al
I wish to automatically enter a zero across multiple non-adjacent cells so as
to "refresh" a template at the beginning of a calculation. I have 255 such
ranges, although these cell are not yet set up as ranges. (eg j17:t52,
w17:z52, j59:t78, w59:z78......)
I currently keep an empty row - no data, only zeros - and each time I
refresh the spreadsheet I simply copy and paste the empty row across the rows
containing data. I works, but I think there could be an easier way?
Is there such a thing as "set range1, range 2.....range 255 = 0"?
to "refresh" a template at the beginning of a calculation. I have 255 such
ranges, although these cell are not yet set up as ranges. (eg j17:t52,
w17:z52, j59:t78, w59:z78......)
I currently keep an empty row - no data, only zeros - and each time I
refresh the spreadsheet I simply copy and paste the empty row across the rows
containing data. I works, but I think there could be an easier way?
Is there such a thing as "set range1, range 2.....range 255 = 0"?