| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveCell.Formula to equal a specific cell
I'm trying to set my active cell to equal B34. But when I do it, the formula
is in R1C1 format. Next time the macro runs, B34 will be in a different position relative to my active cell. What should the code look like if I want ActiveCell.Formula = B34??? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to Revert to ActiveCell.Formula = format from ActiveCell.FormulaR1C1 = format | Excel Programming | |||
| Having a cell equal a specific day of the week? | Excel Programming | |||
| How do I set a formula in a cell to equal the total in another ce. | Excel Worksheet Functions | |||
| Trigger macro if an Activecell is within a specific Range | Excel Programming | |||
| Trigger macro if an Activecell is within a specific Range | Excel Programming | |||
Threaded Mode
