| 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??? |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveCell.Formula to equal a specific cell
Try,
Range("b34").Copy With ActiveCell .PasteSpecial End With Mike "Aaron" wrote: 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??? |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
ActiveCell.Formula to equal a specific cell
or one of these:
Activecell.Formula = "=$B$34" or ActiveCell = Range("B34").Value "Mike H" wrote: Try, Range("b34").Copy With ActiveCell .PasteSpecial End With Mike "Aaron" wrote: 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??? |
| Reply |
| 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 | |||
Linear Mode
