| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Apply a R1C1 function to a specific range
Hi!
I use the following function: Range(Cells(i, 13), Cells(i, 500)).FormulaR1C1 = "=RC[-2]/RC[10]" I would to modify the formula to apply it only when RC[-2] is greater than 0. Thank you! Alex -- Alex St-Pierre |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| modify a macro to apply to a specific range of cells | Excel Discussion (Misc queries) | |||
| Using Relative Reference Function to apply to Range | Excel Programming | |||
| How can I apply the ROUND function to a range of cells in a workbo | Excel Discussion (Misc queries) | |||
| Displaying value of specific cell within a range, with IF function...? | Excel Discussion (Misc queries) | |||
| How to apply a function across a range of cells | Excel Programming | |||
Threaded Mode
