| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
INsert Formula via Macro
Hi all
How do I insert a formula in a column via macro, eg I want to insert =INDEX('C:\[FXAppl.xls]Sheet1'!$C$1:$C$100,MATCH(LEFT(Sheet3!A2,4)&"*",'C :\[FXAppl.xls]Sheet1'!$B$1:$B$100,0)) into column F till the last row with data. Thanks regards, xlsops |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Insert a Formula with a Macro | Excel Discussion (Misc queries) | |||
| Macro to insert formula | Excel Worksheet Functions | |||
| macro to insert into a formula | Excel Worksheet Functions | |||
| HOW DO YOU INSERT A MACRO INTO A FORMULA | Excel Worksheet Functions | |||
| Insert macro into formula | Excel Worksheet Functions | |||
Threaded Mode
