Thread: Convert Formula Result to Static Text
View Single Post
 
Old 08-10-2011, 11:28 PM
Catalin.B Catalin.B is offline Windows Vista Office 2007
Expert
  
Join Date: May 2011
Location: Iaşi, Romānia
Posts: 386
Catalin.B is on a distinguished road
Default
try a simple macro...
Sub Macrocomandă1()
Range("H10:H25").Select
Selection.Copy
Range("I10").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
End Sub
Reply With Quote