Trying to copy Data from one worksheet to another

[stojko89]

Hi

I'm tryn to copy values from A3:F# (untill the values stop). To another worksheet to Cell A3 and down.
I'm tryn this but it gives me an error on the PasteSpecial part. I also tryed just Paste but it still doesn't work.

Please Login or Register  to view this content.

[abousetta]

Try:

Please Login or Register  to view this content.

abousetta

[stojko89]

Ok that worked. Thank you

But my other problem is that it copys the range but if says in Column F I have a few cells empty it doesn't copy them:

A3:E7 ----> Cells have Values
F3:F5 ----> Cells have Values but Cells F6 and F7 don't have Values and so it doesn't copy Values from Row 6 and 7?
And I also don't want all the sheets to have to become active for the codes to work it's a confusen when you run the makro and the excel starts poping from one sheet to another.
Can I somehow avoid that?

My code is this:

Please Login or Register  to view this content.

[stojko89]

The UserForm that this VBA is connected to is on Sheet "Povprasevanja" and then it makes the "Narocila" Sheet active to do something and then it makes sheet "POV2011-001" active to do something else. So thats the confusing part

Any idias about that?

[nilem]

Maybe this:

Please Login or Register  to view this content.

.Cells(Rows.Count, 6) 6 - is the column number on which the last filled cell is determined. Try to use for example 1 (column A)

[stojko89]

nilem.

Yeh that works great! Thank you very much

But now I have a nother problem...in the same code. This is giving me a hard time:
It keeps telling me its a misstype error or something like that

Please Login or Register  to view this content.

[snb]

Most of the time you don't need 'copy' to copy

Please Login or Register  to view this content.