Copy from one sheet to next empty row in another

[chrisellis250]

Hi all,

I have the following code, however there is an 'Object Required' error popping up on the 3rd row (Set rng1 = etc)

Please Login or Register  to view this content.

Any ideas why this is occurring? Or any ideas how to amend it/any alternatives?

Kind Regards,

[jindon]

When/how did you assign the value to "LastRow"?

Please Login or Register  to view this content.

[chrisellis250]

I've just realised that is part of my issue - I have added in

Please Login or Register  to view this content.

I am now getting an error on the last row of code.

[Richard Buttrey]

I note you haven't dimmed the LastRow variable - although I think that would give you a different error message than the one you describe. And although you've dimmed a rng2 you're not using that.

That said try something like the following

Please Login or Register  to view this content.

[jindon]

Your code should not raise the error at "(Set rng1 = etc)", as long as you have Sheet11.
For the safety, add a period before Rows.Count

Please Login or Register  to view this content.

[jindon]

I've just realised that is part of my issue - I have added in

Please Login or Register  to view this content.

I am now getting an error on the last row of code.

Declaring variable doesn't mean assigning value to it.

try
change to

Please Login or Register  to view this content.

[chrisellis250]

Im getting a 'Run-time error '1004'': Method 'Range' of object'_Worksheet' failed on the following:

Please Login or Register  to view this content.

[chrisellis250]

Apologies, your most recent code did the trick. Thanks guys, got a bit muddled!

[jindon]

No problem.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.