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
|
