View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] rumkus@hotmail.com[_2_] is offline
external usenet poster
 
Posts: 60
Default copy paste problem

Give a try this:

With Worksheets("Formulas").Range("A1:IV5000")
..Value = .Value
End With