Results 1 to 8 of 8

VBA code remove all formulas from entire workbook without losing original file

Threaded View

Pankaj jaswani VBA code remove all formulas... 04-15-2022, 07:55 AM
cytop Re: VBA code remove all... 04-15-2022, 08:00 AM
Pankaj jaswani Re: VBA code remove all... 04-15-2022, 08:33 AM
cytop Re: VBA code remove all... 04-15-2022, 08:44 AM
Pankaj jaswani Re: VBA code remove all... 04-15-2022, 08:51 AM
cytop Re: VBA code remove all... 04-15-2022, 09:14 AM
Pankaj jaswani Re: VBA code remove all... 04-15-2022, 09:26 AM
Pankaj jaswani Re: VBA code remove all... 04-15-2022, 09:41 AM
  1. #1
    Forum Contributor
    Join Date
    07-27-2018
    Location
    Jodhpur, India
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 Pro 64-bit)
    Posts
    405

    VBA code remove all formulas from entire workbook without losing original file

    Hello Expert,

    I have a VBA code that remove all formulas from the entire workbook. However, it is now working on the file where the code will be executed. Is it possible that if we select a file that needs all of the formulas removed, it will not spoil that file and instead make a copy without the formulas in the preset folder or the same directory, depending on which choice we choose? Please assist me if this is possible. Thank you in advance.

    Sub Convert2Values()
        Dim oSh As Worksheet
        For Each oSh in Worksheets
            oSh.UsedRange.Value = oSh.UsedRange.Value
        Next
    End Sub

    PJ


    Learning One New Thing Everyday!

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Create new workbook named for Cell in original workbook and copy some sheets from original
    By ANDREAAS in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-09-2019, 01:40 PM
  2. "file opener" - code to open another workbook, save as, and close both original files
    By Arnold Layne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-10-2019, 01:08 PM
  3. remove entire row from the whole workbook contains a persons name.
    By chriswrcg in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-02-2018, 08:35 AM
  4. Replies: 5
    Last Post: 03-30-2016, 12:32 PM
  5. [SOLVED] How to copy formulas to new workbook without referencing original source
    By TPS in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-11-2013, 08:47 PM
  6. Error when executing VBA code to remove all formulas from Workbook
    By brharrii in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 06-17-2013, 05:17 PM
  7. Formulas are pasting with references back to original workbook.
    By ugogirl2005 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-02-2012, 10:41 AM

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