Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 3 of 3

Thread: [Solved] VBA: remove formula and keep value

  1. #1
    Join Date
    21st July 2003
    Posts
    40
    Is there a way I can remove all formulas in a column/range and still keep the value calculated by those formulas in VBA?

    Thanks,
    Philip

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    25th January 2003
    Location
    Scotland
    Posts
    1,462
    Hi Philip,
    Range("A1:A10").formula="=20*10"
    Range("A1:A10").value=range("A1:A10").value

    Regards,

    Bill

    Excel Video Tutorials / Excel Dashboards Reports


  3. #3
    Join Date
    21st July 2003
    Posts
    40
    Thanks, Ranger. Your method is much better than what the Paste-Value-Only method I used.

    Philip

    Excel Video Tutorials / Excel Dashboards Reports


Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Remove Formula Bar On Opening
    By I80ROUTE in forum EXCEL HELP
    Replies: 3
    Last Post: December 15th, 2006, 11:55
  2. Formula to remove part of text
    By keesberbee in forum EXCEL HELP
    Replies: 2
    Last Post: August 7th, 2006, 15:48
  3. [Solved] VBA : Remove first character
    By L.B. in forum EXCEL HELP
    Replies: 2
    Last Post: January 6th, 2004, 00:12
  4. [Solved] How do I remove a link to a file?
    By Jungles_McBeef in forum EXCEL HELP
    Replies: 2
    Last Post: September 24th, 2003, 12:21
  5. Replies: 1
    Last Post: August 18th, 2003, 05:16

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
  •  
porno