+ Reply to Thread
Results 1 to 7 of 7

Converting Cell Formula to Text

  1. #1
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    326

    Converting Cell Formula to Text

    Greetings,
    I would like to convert the cell formula into a value without using copy/paste. My code is using the copy/special paste method.
    Please Login or Register  to view this content.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,417

    Re: Converting Cell Formula to Text

    Try

    Please Login or Register  to view this content.
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    326

    Re: Converting Cell Formula to Text

    TMS,
    WOW it was soooooo simple. Thank you MUCH for pointing me in the right direction!! I changed your code a bit.
    Please Login or Register  to view this content.

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,417

    Re: Converting Cell Formula to Text

    You're welcome. Thanks for the rep.

    You don't need your amendment. It will work as described ... .Value = .Value

    The dot links the Value property to the range specified in the With statement in both cases

  5. #5
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,417

    Re: Converting Cell Formula to Text

    You could however say

    Please Login or Register  to view this content.
    And then you don't need to use the With ... End With construct

  6. #6
    Forum Contributor
    Join Date
    07-07-2017
    Location
    USA
    MS-Off Ver
    2010
    Posts
    326

    Re: Converting Cell Formula to Text

    TMS,
    Yep, that worked as well!
    Thank you VERY much for this bit of info. I will NEVER use copy/paste again!!!!

  7. #7
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2003,2007,2010
    Posts
    29,417

    Re: Converting Cell Formula to Text

    Again, you're welcome.

    The With ... End With construct is used for brevity and efficiency.

+ Reply to Thread

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