Hi

Can anyone see why this fails with this error:

Run-time error '1004': Method 'range' of object '_Worksheet' failed.

when I try to run this code:

when both rTarget is a properly initialized range object and iRow is a properly initialized integer?

Thanks

wstTarget.Range(rTarget).Value = _
wstSheet.Cells(iRow, 4).Value

You didn't provide any detail of how 'rTarget' is defined. Having a multi cell 'rTarget' range object would mess up the recipe.

Did you define 'rTarget' as a range or a String? It would have to be a String Value for that application?

Hi again

Looking at your previous post where rTarget is a range object then the code here should be

wstTarget.Range(rTarget.Address).Value = _
wstSheet.Cells(iRow, 4).Value

Then Range() need the cell address as sstring, not an object!!

MTB