Page 1 of 1

Error: Parameter #1 of rrrequires a variable reference, but received a ComObject.

Posted: 03 May 2023, 04:43
by cgx5871

Code: Select all

rng:=xl.Selection
rr rng
rr(&rng)
{
}
how to byref xl.range?

Re: Error: Parameter #1 of rrrequires a variable reference, but received a ComObject.  Topic is solved

Posted: 03 May 2023, 05:47
by swagfag
prepend an & at the callsite as well

in any case, the correct byref usage is explained in the docs, so maybe read them?