Looking for code to grab the name of a active worksheet and open another workbook find the same named work sheet and copy a data range to the second work book.
Sheet names in both workbooks are the same. Jan 14, Feb 14, Mar 14,....
I want the user to be able to update the date in a range of the first book the hit a button to update the second book and save the second book.
may be this below.
Please Login or Register to view this content.
Give Feedback and Click(*)
Hi, Frank Harrison,
maybe like this:
Ciao,Please Login or Register to view this content.
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
or
Please Login or Register to view this content.
Regards, John55
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.
...enjoy -funny parrots-
Hi, john55,
any particular to build a range object on a Selection just to copy it?
to whom it may concern:
AFAIK the Aplication name should read Excel, not Exlcel.
Ciao,
Holger
Hi HaHoBe,
I am sorry if I did a mistake and I think I did answering, I do not want to upset anybody...
I thought that the OP wants the user to be able to change the range...
sorry again!
Hi, john55,
don´t always be afraid that you may have done anything wrong - there´s nothing wrong with adding a sample code. It´s just a matter of me being curious as I personally would only set a Range if I were to use it for other purposes as well. The only purpose you use it for is to copy, and I guess that could be done without setting a range like in the original post. It´s a matter of taste (and I tend to have a bad taste these days) - that´s all. And I tend to be asking things like the proper use of Variable way too much.
And using Selection would make it unnecessary to hard code the ranges although I personally don´t like it too much if the user has to choose a range prior to running a macro (maybe you should add a code-line which refuses to run the code if only one cell is selected leaving it open if 2 selected cellls really is the range that shoulöd be copied, could be asked via MsgBox).
And: no reason to be or feel sorry (from my point of view), any forum lives from people contributing, and if you stop doing so because I replied I would have to feel sorry.
Ciao,
Holger
Last edited by HaHoBe; 03-01-2014 at 08:40 AM.
Holger, Thx for your response!
No problem, not at all! Frank did not specified that he used a specific range and then he said that he needed the user to be able to change...starting from here I thought that every time he has a different range and the user needs to select the desire area for copying.
I am in a learning process!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks