+ Reply to Thread
Results 1 to 2 of 2

Need VBA to take all the formulas out from specific cells and columns

  1. 07-23-2013, 10:59 AM #1
    tantcu is offline
    Forum Contributor
    Join Date
    07-16-2012
    Location
    Fort Worth, Texas
    MS-Off Ver
    Excel 2010
    Posts
    378

    Need VBA to take all the formulas out from specific cells and columns

    Hi,

    I'm looking for a VBA that can take all the formulas out from specific range like range O32:P3505, and range AD32:AX3505 from the worksheet named BAT. Appreaciate if you can help. Thanks.
    Reply With QuoteRegister To Reply
  2. 07-23-2013, 01:25 PM #2
    Mumps1 is offline
    Forum Expert Mumps1's Avatar
    Join Date
    10-10-2012
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2010, 365
    Posts
    8,056

    Re: Need VBA to take all the formulas out from specific cells and columns

    Try:
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Adding Record to data table + preserve array formulas in specific columns
    By olivierpbeland in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-21-2013, 02:33 PM
  2. Excel 2007 : Linking formulas to labels rather than specific cells
    By nationalsfan in forum Excel General
    Replies: 3
    Last Post: 07-02-2012, 04:56 PM
  3. Formulas to retrieve online form submitted data from unknown cells/rows to specific cells
    By 211terra in forum Excel General
    Replies: 0
    Last Post: 04-05-2012, 10:37 AM
  4. Pasting formulas in specific columns
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 02-08-2011, 12:12 PM
  5. [SOLVED] Is there a way to eliminate specific cells from formulas?
    By Valerian in forum Excel - New Users/Basics
    Replies: 9
    Last Post: 04-03-2006, 05:10 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1