Copying formula in one workbook, pasting its value in other workbook

[Jeffrey Lebowski]

Hello,

I have the code below, which is working spiffy for me to copy data from one workbook to another. The problem is, the last range that I copy is formulae in the origin workbook...but I only want their values (or else I get the evil #REF! error). I am thinking there is a simple tweak that must be made to the code to enable this, but I struck out in my searches.

Please Login or Register  to view this content.

[fonzie29]

Hi Jeffrey,

Try this code,

Please Login or Register  to view this content.

Thanks,
Fonzie

[Jeffrey Lebowski]

Thanks for your help!! I ended up changing it a little more because I want it to paste in next free column so I went with the select case. Getting more brave experimenting with vba each day and I'm proud of this baby! if you care, check it out below.

Please Login or Register  to view this content.