Announcement

Collapse
No announcement yet.

[Solved] VBA: remove formula and keep value

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • [Solved] VBA: remove formula and keep value

    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

  • #2
    Hi Philip,
    Range("A1:A10").formula="=20*10"
    Range("A1:A10").value=range("A1:A10").value

    Regards,

    Bill

    Comment


    • #3
      Thanks, Ranger. Your method is much better than what the Paste-Value-Only method I used.

      Philip

      Comment

      Working...
      X