Trying to set a negative Offset - Error 9

[Scoobster_doo]

Hi Guys,

I'm looking to paste some copied data higher up my row than its doing so however when setting a negative offset it comes up with error 9.

Please Login or Register  to view this content.

That's the code above. It starts the paste in Row 10 and I'm wanting it to start in row 4.

I try to change the offset to -5 however an error pops up, any ideas why?

Thanks in advance

[YasserKhalil]

Not sure of what you need exactly but if you need to start in row 4 why don't you use this line instead

Please Login or Register  to view this content.

[Scoobster_doo]

It was my error, when copying to the array I was accidently copying about 6 blank spaces which were pasting hence why my paste was pushed so far down!

However your solution would have worked should it not have been that so thank you +rep

[YasserKhalil]

You're welcome. Glad it worked for you and thanks for the rep points