Thread: [Solved] Is it correct (PasteSpecial function)
View Single Post
 
Old 01-07-2012, 03:36 PM
JBeaucaire JBeaucaire is offline Windows XP Office 2003
Advanced Beginner
  
Join Date: Dec 2011
Posts: 51
JBeaucaire is on a distinguished road
Default
A FUNCTION() is by definition a formula. If it is used in a cell, that is.

However a macro can be invoked to run on the activecell. This macro will convert the current selected cells into flat values:

Code:
Sub RemoveFormulas()
    Selection.Value = Selection.Value
End Sub
Reply With Quote