ActiveCell.Formula to equal a specific cell

's Computer Specifications

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???

's Computer Specifications

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???

's Computer Specifications

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???

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
formula if one cell doesn't equal another cell	Brandy	Microsoft Excel Misc	4	12th Aug 2008 05:00 PM
Having a cell equal a specific day of the week?	nbaj2k	Microsoft Excel Programming	10	10th Aug 2006 12:32 PM
How do I set a formula in a cell to equal the total in another ce.	=?Utf-8?B?ZGl6enlk?=	Microsoft Excel Worksheet Functions	1	18th Mar 2005 05:50 PM
formula to equal a pie graph inside a cell	Tiia	Microsoft Excel Worksheet Functions	0	19th Aug 2004 07:19 PM
Formula to update cell w/ActiveCell.Value?	Ed	Microsoft Excel Discussion	3	12th May 2004 02:14 PM