+ Reply to Thread
Results 1 to 4 of 4

need macro: convert formula to value

  1. #1
    moshe
    Guest

    need macro: convert formula to value

    I dont want to see formula at selection area , only values
    need macro to do so.

  2. #2
    Tom Ogilvy
    Guest

    Re: need macro: convert formula to value

    Turn on the macro recorder

    then select your cells, format => cells, go to the protection tab and click
    both locked and hidden

    then protect your worksheet

    Turn off the macro recorder.

    Look at the recorded code.

    --
    Regards,
    Tom Ogilvy


    "moshe" <yuvalbra@gmail.com> wrote in message
    news:f4a9785d.0504060628.2976bffb@posting.google.com...
    > I dont want to see formula at selection area , only values
    > need macro to do so.




  3. #3
    JulieD
    Guest

    Re: need macro: convert formula to value

    Hi

    just wondering why you need a macro for this, as copy then edit / paste
    special - values works well in most situations.

    --
    Cheers
    JulieD
    check out www.hcts.net.au/tipsandtricks.htm
    ....well i'm working on it anyway
    "moshe" <yuvalbra@gmail.com> wrote in message
    news:f4a9785d.0504060628.2976bffb@posting.google.com...
    >I dont want to see formula at selection area , only values
    > need macro to do so.




  4. #4
    Tom Ogilvy
    Guest

    Re: need macro: convert formula to value

    If you actually want to replace the formula with values as JulieD describes

    Sub ReplaceWithValues()
    selection.Copy
    selection.PasteSpecial xlValues
    End Sub

    --
    Regards,
    Tom Ogilvy


    "JulieD" <JulieD@hctsReMoVeThIs.net.au> wrote in message
    news:eu9hrcrOFHA.2144@TK2MSFTNGP09.phx.gbl...
    > Hi
    >
    > just wondering why you need a macro for this, as copy then edit / paste
    > special - values works well in most situations.
    >
    > --
    > Cheers
    > JulieD
    > check out www.hcts.net.au/tipsandtricks.htm
    > ...well i'm working on it anyway
    > "moshe" <yuvalbra@gmail.com> wrote in message
    > news:f4a9785d.0504060628.2976bffb@posting.google.com...
    > >I dont want to see formula at selection area , only values
    > > need macro to do so.

    >
    >




+ 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