paste values not formula

Hi Guys, I currently have this macro Sub COPYTODASH() Application.ScreenUpdating = False Worksheets("DASHBOARD").Range("R26:R26").Copy Worksheets("PROG").Range("C" & Rows.Count).End(xlUp)(2) Application.ScreenUpdating = True End Sub It works as expected, the only problem I'm having is that...

Hi, I have some code which works fine apart from the bit where it copies formulas rather than values across to the new sheet. What am I missing here? Sub Quotetracker()Application.ScreenUpdating = False Sheets("Customer Quote").Range("B11").Copy _ Destination:=Sheets("Quote...

Hi, I have some code where its picking data from one sheet and dropping it into another. However i just have a small issue with one piece as its pasting the actual formula rather than just the values. can someone advise with what I am missing or what I need here to do it? Sub Copyover...

I need a macro solution to perform the following tasks... 1. Filter column A for all blanks 2. Select first resulting cell and enter a formula in it 3. Copy that formula into columns B thru O then down to last row in filtered list 4. Copy all new formula cells and paste value over them

Hi friends! To paste only values on the visible cells, i use the following macro: <tbody> Sub Copy_Filtered_Cells() Dim from As Variant Dim too As Variant Dim thing As Variant Dim cell As Range 'Selection.SpecialCells(xlCellTypeVisible).Select Set from =...

Sub Test()Sheets("A").Range("D93:M93").Copy Sheets("B").Range("D" & Rows.Count).End(xlUp).Offset(1, 0)End SubThe above worked great, but it pasted the formulas within the cell instead of the values.</PRE>

Hi, I am trying to copy only the values (NOT the formulas) from one location to another. My current code is: With Sheets("Main Page") .Range("G12", .Range("G" & Rows.Count).End(xlUp)).Copy _ Sheets("Comparison").Range("B" & Rows.Count).End(xlUp)(2) End With Obviously, this...