| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can anyone tell me If this can be done
With Range(Current_Sheet)
.FormulaR1C1 = "=SUMIF(NDIRECT(R5C),RC1,OFFSET(NDIRECT(R5C),0,R1C ,ROWS(NDIRECT(R5C)),1))" .Value = .Value End With The indirect is referencing the cell that contyains the name of a defined range name in another worksheet Any help would be really appreciated -- Helping Is always a good thing |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can anyone tell me If this can be done
At a glance, the formula will not work because the function NDIRECT does not
exist in Excel. Probably a typo, but it should be INDIRECT. "QuietMan" wrote: With Range(Current_Sheet) .FormulaR1C1 = "=SUMIF(NDIRECT(R5C),RC1,OFFSET(NDIRECT(R5C),0,R1C ,ROWS(NDIRECT(R5C)),1))" .Value = .Value End With The indirect is referencing the cell that contyains the name of a defined range name in another worksheet Any help would be really appreciated -- Helping Is always a good thing |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Can anyone tell me If this can be done
Thanks, this is what happens at 2am in the morning
-- Helping Is always a good thing "JLGWhiz" wrote: At a glance, the formula will not work because the function NDIRECT does not exist in Excel. Probably a typo, but it should be INDIRECT. "QuietMan" wrote: With Range(Current_Sheet) .FormulaR1C1 = "=SUMIF(NDIRECT(R5C),RC1,OFFSET(NDIRECT(R5C),0,R1C ,ROWS(NDIRECT(R5C)),1))" .Value = .Value End With The indirect is referencing the cell that contyains the name of a defined range name in another worksheet Any help would be really appreciated -- Helping Is always a good thing |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
