Hi.
I have 4 sheets (Copy, Paste2, Paste3, Paste4).
I need, case target is in range ("E2:E67") then copy to tab Paste2 in column A
Case target is in range ("F2:F67") then copy to tab Paste3, Case target is in range ("G2:G67") then copy to tab Paste4.
i tri code below, but not work.
Thank you
Please Login or Register to view this content.
Last edited by marreco; 09-20-2016 at 01:39 PM.
"No xadrez nem sempre a menor dist?ncia entre dois pontos ? uma linha reta" G. Kasparov.
If your problem is solved, please say so clearly, and mark your thread as Solved: Click the Edit button on your first post in the thread, Click Go Advanced, select b from the Prefix dropdown, then click Save Changes. If more than two days have elapsed, the Edit button will not appear -- ask a moderator to mark it.
Explain exactly what you mean by....but not work.
....and why are the sheet names in your post different to the sheet names you describe in the code?
Sheets("Plan2").Range("A" & lrTab2).Value = Target.Value
sht2 = ThisWorkbook.Worksheets("Paste2")
copy to tab Paste2 in column A
Last edited by WasWodge; 09-20-2016 at 01:44 PM.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
Because i forgot edit...look now.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
and so the other question?
and what exactly are you expecting to happen do with the lines below?Explain exactly what you mean by
but not work.
and think... is it possible to have 3 non-contiguous targets at the same time?Please Login or Register to view this content.
Edit: it seems AlphaFrog has guessed correctly what the OP's objective was.
Last edited by WasWodge; 09-20-2016 at 02:01 PM.
Hi AlphaFrog, thank very much!!!!!!!!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks