Can anyone tell me If this can be done

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

QuietMan - 11 Apr 2008 14:51 GMT

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

Signature

Helping Is always a good thing

Reply to this Message

JLGWhiz - 11 Apr 2008 16:50 GMT

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.

> With Range(Current_Sheet)
> .FormulaR1C1 =
[quoted text clipped - 6 lines]
>
> Any help would be really appreciated

Reply to this Message

QuietMan - 11 Apr 2008 18:34 GMT

Thanks, this is what happens at 2am in the morning

Signature

Helping Is always a good thing

> 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.
[quoted text clipped - 9 lines]
> >
> > Any help would be really appreciated

Reply to this Message