+ Reply to Thread
Results 1 to 2 of 2

VBA for converting formulas to text

  1. #1
    Registered User
    Join Date
    05-06-2013
    Location
    toronto,Canada
    MS-Off Ver
    Excel 2010
    Posts
    75

    VBA for converting formulas to text

    Good day everyone, I have a following Worksheet_Activate module under sheet 1, which performs a few actions. But one of he key things it does is convert formulas to text. However it does not seem to work. Would anyone be able to have a look and tell me if potential sources of error exist in the code?

    Please Login or Register  to view this content.

  2. #2
    Valued Forum Contributor
    Join Date
    02-08-2012
    Location
    Newcastle, Australia
    MS-Off Ver
    Excel 2007 and Excel 2010
    Posts
    1,429

    Re: VBA for converting formulas to text

    Hi,

    Could you please attach your workbook with the code and an explanation of what to do, the results that you are getting, and the results that you are expecting?

    Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Converting to Array formulas
    By monu_sonu in forum Excel General
    Replies: 2
    Last Post: 11-23-2012, 07:20 AM
  2. Converting formulas to integers
    By kandor5 in forum Excel General
    Replies: 5
    Last Post: 12-02-2008, 11:52 PM
  3. Converting selective formulas to text
    By josnah in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-21-2008, 11:09 AM
  4. converting concatenated text strings into formulas
    By z.entropic in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-05-2006, 01:20 PM
  5. [SOLVED] converting text to formulas
    By Scot B in forum Excel General
    Replies: 1
    Last Post: 03-01-2005, 09:06 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1