If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

PUTCELL

Thread starter GeertD
Start date Apr 10, 2021

=PUTCELL(Array,RowNr,ColNr,val)

Array: Required.

RowNr: Optional. Row co-ordinate of the cell that gets the value. If omitted or outside of the Array, the Array remains unchanged.

ColNr: Optional. Column co-ordinate of the cell that gets the value. If omitted or outside of the Array, the Array remains unchanged.

val: Optional. (reference to) scalar value. If omitted, the cell will be put to zero.

Put a single value at a precise position in an array. If you try to put the value outside of the array or omit one or both the co-ordinates, the Array remains unchanged.

GeertD

Board Regular

Apr 10, 2021

PUTCELL: Put a single value at a precise position in an array.
If you try to put the value outside of the array, the latter remains unchanged.

Excel Formula:

=LAMBDA(Array,RowNr,ColNr,val,LET(
   RowsA,ROWS(Array),ColsA,COLUMNS(Array),
   Rowdex,SEQUENCE(RowsA),Coldex,SEQUENCE(,ColsA),
   IF(or(RowsA<RowNr,ColsA<ColNr),Array,IF((Rowdex=RowNr)*(Coldex=ColNr),val,Array))
))

DXLR's LAMBDA.LET Library_v00.07.xlsb