Hey James, If you want copy all cell ..then ..Just use Sheet copy and move option then use paste special value function (Alt +E +M)
On Wed, Aug 10, 2011 at 11:29 PM, ja...@macstop.co.uk <ja...@macstop.co.uk> wrote: > Hi, > > This is driving me crazy, can someone help! > > I have a nice pretty worksheet, all coloured in and stuff - all I want > to do is select all the cells and copy - then paste into a new > workbook. > > I can do all of this, but it seems when using pastespecial I have to > select values (because these cells have formulae in that I don't want > to copy) at which point I lose the cell formatting. I have tried > xlPasteValuesAndNumberFormats and pretty much every option I can see. > > There 'must' be a way - surely?! > > PS I am working in 2010 but it has to be backwards compatible down to > 02 > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > -- ......................... -- ---------------------------------------------------------------------------------- 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/discussexcel
