Results 1 to 3 of 3

Most efficient macro to loose any formulas on whole sheet

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-29-2011
    Location
    Bristol, England
    MS-Off Ver
    Excel 2003
    Posts
    471

    Most efficient macro to loose any formulas on whole sheet

    Basically it would simulate Select all, Copy, Paste Special, values.
    Sub Macro2()
        Cells.Select
        Selection.Copy
        Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
            :=False, Transpose:=False
    End Sub


    I bet there is a simple command to achieve the same without copying just via simple macro line. Something that would be more efficient? Or is this already efficient enough?

    Any ideas?


    Cheers
    Rain
    Last edited by rain4u; 02-12-2011 at 04:08 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1