Many thanks. I had actually tried that and it had failed but I've subsequently worked out what was going wrong. The worksheet I was copying from was protected. I just needed to unprotect first and it all works fine now.
On Nov 16, 1:45 pm, Ashish Jain <[email protected]> wrote: > 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.comhttp://www.openexcel.com > ________________________________________ > > On Nov 16, 6:08 pm, Mike Magill <[email protected]> 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?- Hide quoted text - > > - Show quoted text - -- ---------------------------------------------------------------------------------- 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
