( log69 | 2020. 04. 23., cs - 20:28 )

Szerkesztve: 2020. 04. 23., cs - 20:29

Közben találtam infót:


Arguments passed to a macro from Calc are always values. It is not possible to know what cells, if any, are used. For example, =PositiveSum(A3) passes the value of cell A3, and PositiveSum has no way of knowing that cell A3 was used. If you must know which cells are referenced rather than the values in the cells, pass the range as a string, parse the string, and obtain the values in the referenced cells.

Akkor string-ként passzolon a RANGE-et és onnét hivatkozok vissza a cellákra, ahol már lesz infóm a típusra és másra.