Copying rows into the incorrect rows in another worksheet

[Roo2021]

Hi All,

I'm very new to the world of VBA coding & this is my first time of posting.
I have written some code which copies certain information from one worksheet (when a particular condition is met) into another worksheet but the copied rows are pasted further down in the worksheet:

I want them to come in at row 3 but they are dropping in at row 4000:

Any ideas would be greatly received.

Thanks

 

[Joe4]

What does this formula return (place it any blank cell on your "Error_Report" sheet)?
=LEN(B3999)

If it returns anything other than 0, then the issue is you have a non-blank entry in cell B3999.

 

[Marc L]

Hi,​

​

the cells formatting can be also an issue so must use the Range.Find method …​

 

[Roo2021]

What does this formula return (place it any blank cell on your "Error_Report" sheet)?
=LEN(B3999)

If it returns anything other than 0, then the issue is you have a non-blank entry in cell B3999.

Hi Joe4, thankyou for your suggestion, I will look into it.

 

[Roo2021]

Hi,​

​

the cells formatting can be also an issue so must use the Range.Find method …​

Hi Marc L, thank you for your reply, I will look into it.