Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range - Formula
Not sure what you want but try this;
type your name in the address box on the top-left and press enter this will select the named range type your formula and then press CTRL-ENTER ... your formula will be copied to all cells in the range. " VLOOKUP fORMULA" wrote: 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range - Formula
I am sorry Sheeloo, I was asking for a code
In the below code I have to apply the formula in D10 Range("Range1").FillDown I was trying to enter a forumla =sum(a1+a2) in all cells (D10:D20) without applying a formula manually in D10. "Sheeloo" wrote: Not sure what you want but try this; type your name in the address box on the top-left and press enter this will select the named range type your formula and then press CTRL-ENTER ... your formula will be copied to all cells in the range. " VLOOKUP fORMULA" wrote: 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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range - Formula
Try
Range("D10:D20").Select Selection.Formula = "=SUM(A1+A2)" Use SUM($A$! + $A$2) if you want Sum(A1+A2) in all cells and not Sum(A2+A3) and so on " VLOOKUP fORMULA" wrote: I am sorry Sheeloo, I was asking for a code In the below code I have to apply the formula in D10 Range("Range1").FillDown I was trying to enter a forumla =sum(a1+a2) in all cells (D10:D20) without applying a formula manually in D10. "Sheeloo" wrote: Not sure what you want but try this; type your name in the address box on the top-left and press enter this will select the named range type your formula and then press CTRL-ENTER ... your formula will be copied to all cells in the range. " VLOOKUP fORMULA" wrote: 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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range - Formula
I cant define the range as D10:D20, it may vary according to the line
inserted/deleted above. Is there any other way to define the formula using range name (Range1)? tks "Sheeloo" wrote: Try Range("D10:D20").Select Selection.Formula = "=SUM(A1+A2)" Use SUM($A$! + $A$2) if you want Sum(A1+A2) in all cells and not Sum(A2+A3) and so on " VLOOKUP fORMULA" wrote: I am sorry Sheeloo, I was asking for a code In the below code I have to apply the formula in D10 Range("Range1").FillDown I was trying to enter a forumla =sum(a1+a2) in all cells (D10:D20) without applying a formula manually in D10. "Sheeloo" wrote: Not sure what you want but try this; type your name in the address box on the top-left and press enter this will select the named range type your formula and then press CTRL-ENTER ... your formula will be copied to all cells in the range. " VLOOKUP fORMULA" wrote: 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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Range - Formula
Try
Range(ActiveWorkbook.Names("Range1").RefersToRange .Address).Select Selection.Formula = "=SUM(A1+A2)" -------------- Click 'Yes' if this helped. " VLOOKUP fORMULA" wrote: I cant define the range as D10:D20, it may vary according to the line inserted/deleted above. Is there any other way to define the formula using range name (Range1)? tks "Sheeloo" wrote: Try Range("D10:D20").Select Selection.Formula = "=SUM(A1+A2)" Use SUM($A$! + $A$2) if you want Sum(A1+A2) in all cells and not Sum(A2+A3) and so on " VLOOKUP fORMULA" wrote: I am sorry Sheeloo, I was asking for a code In the below code I have to apply the formula in D10 Range("Range1").FillDown I was trying to enter a forumla =sum(a1+a2) in all cells (D10:D20) without applying a formula manually in D10. "Sheeloo" wrote: Not sure what you want but try this; type your name in the address box on the top-left and press enter this will select the named range type your formula and then press CTRL-ENTER ... your formula will be copied to all cells in the range. " VLOOKUP fORMULA" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Range Formula | Excel Discussion (Misc queries) | |||
help with formula range | Excel Discussion (Misc queries) | |||
conditional formula: sum a range if text present in another range | Excel Discussion (Misc queries) | |||
formula to sort a range so that it matches the exact rows of a column that is outside that range? | Excel Discussion (Misc queries) | |||
Sum Formula that excludes other sum formula in range | Excel Worksheet Functions |