Hi Mike,
Try this:
RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR -
5).Formula
= NWR.Range("A6:CN" & LastRow_NWR).Formula
________________________________________
Thanks & Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
________________________________________
On Nov 16, 6:08 pm, Mike Magill <mike.mag...@gmail.com> wrote:
> I have a macro that copies a large range of cells that contains a
> mixture of cells with values and text and other cells with formulae.
>
> I want to copy this range into a new workbook using VBA but I can't
> seem to retain the formulae (which are converted to their values). I'm
> sure there is a simple solution but I'm struggling to find it.
>
> I've tried two ways that don't work so far and included snippets from
> my macro below to show you what I've tried:
>
> Attempt 1:
>
> NWR.Range("A6:CN" & LastRow_NWR).Copy RR.Range("A" & LastRow_RR + 1 &
> ":CN" & LastRow_RR + LastRow_NWR - 5)
>
> Attempt 2:
>
> Data1 = NWR.Range("A6:CN" & LastRow_NWR)
> RR.Range("A" & LastRow_RR + 1 & ":CN" & LastRow_RR + LastRow_NWR - 5)
> = Data1
>
> Can anyone help?
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
