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?
Automating Paste Special is usually easy. Can you describe more fully what you need to do?
Regards,
Patrick
I wept for myself because I had no PivotTable.
Then I met a man who had no AutoFilter.
Microsoft MVP for Excel, 2007 & 2008
If the used range is not too large you can also get rid of the formulas this way...
[VBA]
Option Explicit
Sub ValuesOnly()
With ActiveSheet.UsedRange
.Value = .Value
End With
End Sub
[/VBA]
You know you're really in trouble when the light at the end of the tunnel turns out to be the headlight of a train hurtling towards you
The major part of getting the right answer lies in asking the right question...
Made your code more readable, use VBA tags (this automatically inserts [vba] at the start of your code, and [/vba ] at the end of your code) | Help those helping you by marking your thread solved when it is.
Posting Permissions
Reply With Quote
