How to refer to the cell containing the formula?
Hi all!
Sometimes, I usually end up in a problem while creating UDFs which refer to
the cell actually containing the same. I usually use ActiveCell technique but
in a loop in a sub procedure its OK while when used in a UDF the ActiveCell
is always different where the cursor is place.
Furthermore, sure would oblige if one would kindly provide the code for
simple formula of reversing the column values like the following, as a UDF:
=OFFSET($D$1,ROWS($D$1:$D$20)-ROWS($A$1:A1),0)
--
Thanx in advance,
Best Regards,
Faraz
|