| Home |
| Search |
| Today's Posts |
|
#10
Posted to microsoft.public.excel.programming
|
|||
|
|||
user defined function which increase consecutively while passing below cells
Hi Oercim,
Am Thu, 7 Mar 2013 05:02:05 -0800 (PST) schrieb oercim: I want to modify this function a little bit. Let my function returns always "1" as I drag the function down. But while doing this, I want to store above's function's values as variable; let say this variable's name is "x". I mean, the function will return always 1 as I drag the function down, but x will increase consecutively (like 1,2,3,...). But x will not be dispayed in the sheet. It will just stored, and assigned to draged cell. This is realy the last one. why do you need this function? I am asking that because I am searching a new and better way to do it. Regards Claus Busch -- Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cells w/ user defined function do not auto update | Excel Worksheet Functions | |||
| Making Changes to Cells from a user defined function | Excel Programming | |||
| Excel - User Defined Function Error: This function takes no argume | Excel Programming | |||
| Need to open the Function Arguments window from VBA for a user defined function. | Excel Programming | |||
| Obtaining column/row numbers of cells in user defined function | Excel Programming | |||
Threaded Mode
