F
Faraz A. Qureshi
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)
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)