Thread: Range - Formula
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
VLOOKUP fORMULA  VLOOKUP fORMULA is offline
external usenet poster
 
Posts: 32
Default Range - Formula

Any one please help me......?

Is there any way to give a formula to a named range.
for example:-

I have given a name Range1 for D10:D20
I need to give a formula <a1+a2
and copy the formula to D10:D20

Tks