Hey folks
Cant get copying between two non-active sheets to work. The sheets are "Materialer" and the last sheet in the workbook.
Among lots of attempts I have for instance following two of which neither works:
Please Login or Register to view this content.I havePlease Login or Register to view this content.The attachment probably says more.Please Login or Register to view this content.
Thanks a lot!
Can you quickly summarize what you are trying to accomplish? Which data should be copied and where? Based on what condition?
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
Thanks for the reply.
The idea is that if what I type into the combobox has a matching sheet, then that sheet is activated. If there is no matching sheet, a sheet with the combobox name is created, and into this sheet I then want Range("a1", Cells(LastRow,3)) from sheet "Materialer" copied.
Hi timtim89
Add the Dot before Cells (as in .Cells)Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Aha i see! Thanks a lot!
Your welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks