| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Assign the cell address with a function
Hi all,
I want to calculate the sum of a column, for example the sum from A1 to A10 which is the function =sum(A1:A10). But instead of A10 which identifies the last cell of the sum, I want the row number to be taken from a function that returns an integer number. Thus, the last cell of the sum in the row may be A10 or A12 etc according to the integer which my function will return. Can anybody help me? If I should program it with macros how can I do that? Thanks in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Get cell address from macro function argument | New Users to Excel | |||
| ADDRESS function - dynamic input cell | Excel Discussion (Misc queries) | |||
| Function syntax to compare cell contents | Excel Worksheet Functions | |||
| How do I obtain the address of a cell using the vlookup function? | Excel Worksheet Functions | |||
| How do I use a function to return the address of a cell? | Excel Worksheet Functions | |||
Threaded Mode
