Copying multiple cells formula and paste as Values in same locations

  • Thread starter Thread starter William Poh Ben
  • Start date Start date
W

William Poh Ben

Hi,

I hope someone can help me with a code to handle this problem I hav
been facing at work.

Column AW (Order Qty) and column DZ (Order By) are the vlookup formula
that display the result.
The PartNumbers are filtered that show only selected rows.


How can I selectively copy certain formula cells and paste as onl
values in the same cells again ?

Thanks so much in advance.


columnA columnAW columnDZ
PartNum. Ord.Qty OrderBy
row228 100-344 223 SIEMENS
row610 10-236W 173 SONY
row997 2202246 454 HITACHI
row2169 2244W 680 PHILIPS
row9907 33490 998 DEL
 
Hi William

Pastespecial will not work the way you need.

With a macro you can do this

Sub Values_10()
Dim smallrng As Range
For Each smallrng In Selection.Areas
smallrng.Value = smallrng.Value
Next
End Sub

Other examples you find here
http://www.rondebruin.nl/values.htm
 
Back
Top