| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Putting a formula in the first empty cell in a row
Can anyone help me with code that can put a formula in the first empty cell
in a row? Basically, I want to replace the B3 in the following formula so that it will put the formula in the first empty cell in row 3. I'm trying to make the following formula dynamic. Range("B3").FormulaR1C1 = "=SUM(R[1]C[-2]:R[65535]C[-2])" any help would be appreciated. -- Regards, timmulla |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I assign a value to a cell without putting a formula in it | Excel Worksheet Functions | |||
| Error putting a formula in a cell with vba | Excel Programming | |||
| putting a string from one cell in the formula of another -- indirect needed? | Excel Worksheet Functions | |||
| Putting Formula in Cell | Excel Programming | |||
| Putting Array Formula into each Cell in a Selection (that doesn'ttake eons!) | Excel Programming | |||
Threaded Mode
