"Ed" wrote in message
...
When you bring up Paste Special witha right click, you can choose to paste
only formats, or formulas, or values, etc., but not more than one. With
VBA, can I PasteSpecial format AND values, but NOT formulas?

Hi Ed,

VBA is the same as the UI in this regard. You can perform as many
PasteSpecial operations in a row as you like, though, in order to get the
combination you're after.

--
Rob Bovey, MCSE, MCSD, Excel MVP
Application Professionals
http://www.appspro.com/

* Please post all replies to this newsgroup *
* I delete all unsolicited e-mail responses *