| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to use VBA write formula
Hello Guys,
I want to set a range value to a formula which reference to another closed workbook range. but, I don't know how? example: rng.formulaR1C1="=vlookup("+search+",rng in [another closed workbook]sheetname!"+"r9c9, 9)" thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Write a Formula | Excel Worksheet Functions | |||
| Is there a better way to write formula | Excel Discussion (Misc queries) | |||
| Write formula to look for 'like' value | Excel Discussion (Misc queries) | |||
| How do I write this formula | Excel Discussion (Misc queries) | |||
| how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Threaded Mode
