Copy and Paste from one worksheet to another in the same position

[vwyeth]

Hi

I am trying to write a macro which will copy data from one worksheet to another in the same workbook.
I need to first be able to select the cells where there is a formula and then copy the results of the formula into the same location but onto a different worksheet.

Please Login or Register  to view this content.

I hope someone can help me please

[HaHoBe]

Hi, vwyeth,

LColumn is given no value so it will be 0 and raise an error. And you missed the closing Next for the loop in the sample.

Maybe try it like this:

Please Login or Register  to view this content.

Ciao,
Holger

[vwyeth]

This works a treat! Thanks very much.