I currently use a sheet to price a particular type of financial instrument. The pricer is about 4 columns wide and extends down maybe 50 rows. I simply copy and paste it over when I want to make price a new instrument. The sheet uses an add-in to pull in live market data. In certain situations I copy and paste values in the cells of a particular iteration that are pulling in live data in order to create a snap shot. Id like to write some vba code to do this copy/paste values (easy enough). What Im not sure how to do (or if its possible) is embed a button that executes the code in a cell so that when I copy and paste to start a new pricing iteration, the button copies over with it. It would also need to apply only to that particular set of columns.