PDA

View Full Version : Convert to Values Only



mjensen
09-01-2006, 09:05 AM
I currently have a worksheet that uses a combination of web queries and normal formulas to fill in all the data. However, I need to distribute this worksheet to clients without all the web queries and formulas...just the values. This will be done fairly regularly, so manually using the Copy and Paste Special feature will not be very pratical. Is there a nice way to automate this?

matthewspatrick
09-01-2006, 09:19 AM
Automating Paste Special is usually easy. Can you describe more fully what you need to do?

johnske
09-02-2006, 06:33 AM
If the used range is not too large you can also get rid of the formulas this way...

Option Explicit

Sub ValuesOnly()
With ActiveSheet.UsedRange
.Value = .Value
End With
End Sub