| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range formula copy
Any body please help....
Is there any way to place the below mentioned formula from the second cell (second row) of the range RM1 instead of the first row? Range("RM1").Select ActiveCell.FormulaR1C1 = "=CONCATENATE(LEFT(RC[-2],3))" Range("RM1").FillDown Thanks in advance |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VB copy formula and auto fill a range | Excel Programming | |||
| Macro to copy a cell contains formula to a range | Excel Programming | |||
| copy formula down and ever change range | Excel Programming | |||
| copy formula in a range | Excel Programming | |||
| How to copy formula from one cell to a range? | Excel Programming | |||
Threaded Mode
