Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy and Paste Values not picking up on cells with formulas
Greetings:
I thought I had the following code working. However, it is not copying and placing values in those cells that have an actual formula in them (some also refer to a look-up chart). Cells with no formulas are working properly. The following code is run before any worksheet, row and column deletes are done. When I try a 'manual' copy/paste special, it works fine. Help please. Sub MakeText() ' Convert all Used Cells, on each Worksheet, to Text Dim ws As Worksheet For Each ws In ActiveWorkbook.Worksheets ws.UsedRange.Validation.Delete ws.UsedRange.Copy ws.UsedRange.PasteSpecial xlValues Next End Sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy and paste values, formatting and formulas | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
copy & paste formulas while referring to same cells | Excel Discussion (Misc queries) | |||
Can you copy multiple tabs from formulas to values w/o paste spec? | Excel Worksheet Functions | |||
Dynamic Copy/Paste Special Formulas/Paste Special Values | Excel Programming |