Paste Values Macro

[erock24]

I am in need of a macro that will paste values in a specific column. I was hoping to run this from a button. Which would send a msg box each time asking which column to paste values in. And whatever column is entered is then the only column that changes formulas to values. Is this possible?
It would be very useful.

Thank you very much for your time and help.

[bhofsetz]

Give this a try. You will probably want to add some check to make sure the user only enters a single column in the input box.

HTH

Please Login or Register  to view this content.