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

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

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