| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using a variable in a formula
I have defined this range:
Range("A1").Select Range(Selection, Selection.End(xlDown)).Select Dim Population As Range Set Population = Selection And then I want to use this range in the percentile function, but I haven't been able to figure it out: Range("B1").Select ActiveCell.Formula = "=PERCENTILE(MarketValues,0.2)" Any help would be greatly appreciated. Thanks. Noah |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Variable within a formula | Excel Worksheet Functions | |||
| Using a variable in formula | Excel Programming | |||
| Using a second variable within a formula... | Excel Discussion (Misc queries) | |||
| Variable in a formula | Excel Programming | |||
| Variable to formula. | Excel Programming | |||
Threaded Mode
