Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Refer cell value as part of formula | Excel Worksheet Functions | |||
How do I refer to cell in another worksheet in a formula | Excel Worksheet Functions | |||
Use cell contents to refer to a sheetname in a formula | Excel Worksheet Functions | |||
how i can refer to cell in long formula go to another file | Excel Discussion (Misc queries) | |||
How do I refer to the tab name in a cell formula in Excel? | Excel Discussion (Misc queries) |