Pasting Data to Next Available Cell - Help Much Appreciated

[sypris]

Hello, I am new to the forum and hoping someone can help me out. I am trying to iterate through an if statement and paste certain contents to another sheet - that part is working. However, I can't crack the code on printing to the next avaialble cells so that I don't overwrite my older data.

Here's what I've got, which is throwing an error (object variable or with not set)

Please Login or Register  to view this content.

I am very new to VBA, so if I am missing an obvious convention, it's becasue I have no formal training. Thanks for your help!

Sypris

[AB33]

You are missing to initiate the loop MyLastRow

Please Login or Register  to view this content.

[AB33]

Another way

Please Login or Register  to view this content.

[sypris]

AB33, thanks so much! The first solution was still throwing an exception for some reason, not sure why. But the second one worked perfectly for me. Thanks for your very quick reply. I spent two days trying to do this, I guess I should've posted here sooner!

[AB33]

In which line do you get the error?

[AB33]

Try use this line, instead

Please Login or Register  to view this content.