Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Removing macro's once data is in place

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    362
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Is there a way to remove a formula from a cell without removing the data the formula installed? Once i have the data in each cell, the formula is no longer needed.

    Thanks,
    Noir

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    This should do the trick!

    Formula in sheet1 A1
    Sheet1.Range("A1").Copy
    Sheet1.Range("A1").PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _
    False, Transpose:=False

    Have a nice day!

    Tom

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •