Dear Mudraker,
I've tried your code but it only worked with slight changes. that is before running the macros I have to change to the correspondent sheet, using the instruction Sheets("BC" & i4Cnt).Select. The final code produced was the following:
My question now is if it is possible to change the code so that it works with any workbook name (different from ModeloLCC_3.xls).
Please Login or Register to view this content.
Many thanks for your help
It should it is only a matter of knowing what the book name is
If it is the same book as the macro is in then you can change
toPlease Login or Register to view this content.
Please note in my version of Excel it runs without the ' at the start of the workbookname.Please Login or Register to view this content.
If it is different then you will need to provide the workbookname via a variable
in leiu of ThisWorkbook.Name
Please Read Forum Rules Before Posting
Wrap VBA code by selecting the code and clicking the # icon or Read This
How To Cross Post politely
Top Excel links for beginners to Experts
If you are pleased with a member's answer then use the Scales icon to rate it
If my reply has assistedor failed to assist you
I welcome your Feedback.
Thank you, once again.
Working in perfection!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks