| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Insert a formula into a cell
I want to use VBA to inert a formula into a cell.
I want to get the contents of Cell B7 on the "Balance Sheet" and insert that into cell B$ on the current sheet. Here is what I have but it's not working: Range("B4").Select ActiveCell.FormulaR1C1 = "='Balance Sheet'!B7" When I do that I get a #NAME? error. Help please! And... thanks! Jon |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find a cell and then insert a formula into adjacent cell | Excel Programming | |||
| Insert Formula in Cell with VBA | Excel Programming | |||
| Using VBA to Insert a formula in a cell | Excel Programming | |||
| Insert value of formula into cell | Excel Programming | |||
| insert formula in last cell | Excel Programming | |||
Threaded Mode
