Method Range of object Global failed

Hi,

I've got an oddity with some VBA. I'm using the following code to copy a formula down a dynamic range in some data copy/pasted from another workbook. I've used this many times before and even other places in this workbook. I've even copied the code from a known working section in this same workbook but I'm getting an error in the highlighted line. "Run-time error 1004 - Method Range of object Global failed"

Please Login or Register  to view this content.

Oddly, I've just tried to copy/pastevalues in case it was something funky in the data and although the data has pasted it has also thrown another 1004 error "Unable to set the PasteSpecial property of the worksheet class".

Any ideas? Cheers

Please Login or Register  to view this content.