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 |