Copy Formulas Not Values VBA

[MikeG]

I have the following code which works to copy the values from Range Start1 to Start2. However, what I want to do is copy the formulas from Start1 to Start2.

Can anyone help?

Thanks,

Mike


===========================================
Dim RangeArray As Variant

RangeArray = Sheets("Sheet2").Range("Start1")
Range("Start2") = RangeArray
===========================================

 

[BIGTONE559]

I have the following code which works to copy the values from Range Start1 to Start2. However, what I want to do is copy the formulas from Start1 to Start2.

Can anyone help?

Thanks,

Mike


===========================================
Dim RangeArray As Variant

RangeArray = Sheets("Sheet2").Range("Start1")
Range("Start2") = RangeArray
===========================================

is it just one formula in start1?

 

[Rick Rothstein]

Try it like this...

Dim RangeArray As Range
 
Set RangeArray = Sheets("Sheet5").Range("Start1")
Range("Start2").Formula = RangeArray.Formula

 

[MikeG]

Try it like this...

Dim RangeArray As Range
 
Set RangeArray = Sheets("Sheet5").Range("Start1")
Range("Start2").Formula = RangeArray.Formula

Thanks Rick - that does the job.

Thanks BigTone - and the range has multiple formulas.

MikeG