Paste in Worksheet without choosing the worksheet

[Bob1980]

Hello all,

I am trying to write a macro that pastes data from one tab to another, while only selecting certain information to paste. Currently, the code will only work if I have the tab that I want to paste information into selected. I would like the code to paste data into the worksheet even though it will not be selected. Below is the code.

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

Or just this.

Please Login or Register  to view this content.

[protonLeah]

Please Login or Register  to view this content.

[JBeaucaire]

I'm pretty sure it's CELLS that is a VBA reserved word, CELL is safe to use, though it certainly walks right up to the line, doesn't it?

[Bob1980]

@ Norie, Your code worked like a charm, but I tried to use protonLeah's code first, because I like how the destination range was not specifically defined. The only problem with protonLeah's code was that I kept on getting a "Runtime error 1004", and I think it was because I was trying to copy a whole row.

@protonLeah, is there a way for me to avoid the "Runtime Error 1004" by not copying the whole row?

@JBeaucaire, I agree, I changed the object name to "SiteID".

I modified the SiteCol dimension to refer to a named range, that I defined through the regular worksheet options. And, I did some research on the "Runtime Error 1004"; and it's basically saying that there's an error that VB does not know how to define. So, I'm exploring options on how to only choose part of the row that the value "Unkown" is found on.

Below is the code.

Please Login or Register  to view this content.

I've been doing a lot of updating, so I think my problem is, is that the target

Please Login or Register  to view this content.

is causing the runtime error, and I can't find an alternative way to define the target range to be just columns A:U within the same row as where the cell object finds the value "Unkown". I am getting somewhere?