Hi all

I have just joined here having recently discovered the potential of macros. I came across this thread in my initial search: http://www.excelforum.com/excel-prog...ro-values.html

The code posted by Leith Ross worked perfectly except I would like it to only paste cell values as opposed to the formulas in them. Is this possible or am I looking at building a new macro?