| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using a macro to enter a formula
i'm trying to writ a macro that enters in a formula in a cell.
Scenario: Assume my cursor is in row 8 I want to put a formula of "=O$9" in cell M9 Here's what i've got so far (but its not working) dim x as integer lr=activecell.row 'tells me what row i'm on x=lr+1 'adds 1 to row number cells(x,13).select 'move my cursor to column M of row x ActiveCell.FormulaR1C1 = "=+RxC[2]" 'put the O$x formula in thanks in advance for any assistance. tami |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro to select cells in column enter data then press enter | New Users to Excel | |||
| Enter Static Date with a formula or macro | Excel Discussion (Misc queries) | |||
| What does hitting Ctrl + Shift + Enter to enter a formula do??? Help a n00b out. | Excel Worksheet Functions | |||
| Make macro run when I hit the enter key | Excel Discussion (Misc queries) | |||
| Can you enter a formula in a cell to run a macro? | Excel Worksheet Functions | |||
Threaded Mode
