| Home |
| Search |
| Today's Posts |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Defined names
You are welcome! Thanks for the feedback!
Stefi lesley1000 via OfficeKB.com ezt *rta: Fantastic, thank you for that - I knew that there was a way! Stefi wrote: I couldn't figure out what do you want to do (eg. what is "IS" in Sumif formula, where LAST without a number is defined), but ActiveCell.formula = "=SUMIF(D7:LAST,""IS"",D8:LASTi)" should be written in this way: ActiveCell.formula = "=SUMIF(D7:LAST,""IS"",D8:LAST" & i & ")" Regards, Stefi lesley1000 via OfficeKB.com ezt *rta: I have named in excel 70 cells - I have named them LAST1, LAST2,..., LAST70. They are in the same column, one underneath the other. [quoted text clipped - 19 lines] Any help? -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200712/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to keep names defined after a copy? | Excel Discussion (Misc queries) | |||
| NAMES DEFINED | Excel Discussion (Misc queries) | |||
| List of defined names | Excel Worksheet Functions | |||
| Defined names | Excel Discussion (Misc queries) | |||
| Using non defined names from another sheet | Excel Worksheet Functions | |||
Threaded Mode
