Copy/pasting only values

I am trying to copy data from one column into another using a for loop. The column from where I copy has formulas in it and am trying to just copy the values. I need just the values and not the formula. This is the code I used.

Please Login or Register  to view this content.

Can someone tell me what is going wrong?

The only thing I believe your code is missing is a close to the IF statement and the FOR loop. try this amendment to the code. It resolves your problem and should be more efficient.

Please Login or Register  to view this content.

Hello there,

I tried your code, but it does not seem to be working.

This is the code I am presently using:

Please Login or Register  to view this content.

I am also attaching the worksheet. I am copying values from columns L and N and pasting them in P and R. In P and R,. I need just the values and not the Vlookup function that I used in L and N.

Thanks/