First of all, happy newyear to all users of this forum.
Sorry if I posted the following similar issue before:
I have a macro that copie the filled rows to the first empty row (cell)
Now I wish to customize the macro to copie only the last completed row to the first empty row (cell), meaning the next row.
cover.jpg
Perhaps you should post the macro you want customized.
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.
Good picture. But, the file with code is better.
To do it for me and help me it is 2 different things!
Sorry for my english, blame Google translator
Good idea, stupid me,
Please Login or Register to view this content.
Last edited by fla-ts; 01-07-2017 at 03:52 AM. Reason: forum rules
Moderation Removed. Code Tags Added.
Last edited by Winon; 01-07-2017 at 04:19 AM.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
Think it's okay now
Last edited by fla-ts; 01-07-2017 at 03:53 AM.
Dankie fla-ts,
Please try the Code below:
Kind Regards.Please Login or Register to view this content.
How do I fit this into the macro I have
Hi fla-ts,
They are two different Macros each doing something of their own.
See attachment as sample.
Regards.
Strange, very strange, with your attached excel file the option two works correctly as is wish.
When I try the macro at my file it doesn't, I get an error
Hello fla-ts,
Replace the Code in your workbook with the Code below.When I try the macro at my file it doesn't, I get an error
That's it. Fixed.Please Login or Register to view this content.
SUPER, It works fine, thanks, now i should try the same macro to make one that does the same + delete some of the inputs at the copied row, think this wil not be easy to do.
Hi fla-ts,
If you could tell us what criteria to use to identify which inputs to delete in the copied row, we might be able to assist you further....same macro to make one that does the same + delete some of the inputs at the copied row,...
After copied curtain cels have to empty for example the cel that are under column A C G and K
I think that is difficult to achieve because the copied row is not always the same
Hey, I've been busy today, found the code that does the job.
HTML Code:
Hi fla-ts,
Maybe you have it sorted out now, if so, I am happy for you. However, I have one concern, and that is the ".Range("A" & LR).Resize(2).EntireRow.FillDown".
Please do me a "flavor", and insert a Blank/Empty row between the lines of Data in question, and run the Macro. I am pretty sure it will end at the Blank Row, rendering the Code unreliable. If that is the case, please let me know, so we can find a solution for that problem.
Kind Regards.
- I copie the entire row because there are a lot of formulas in it
- Strage but inserting a Blank/Empty row between the lines of Data in question seems not to be a problem, the macro still does the jop correctly, even with several empty rows beween the data.
Hi fla-ts,
I also tested it on my side, and I concur with your findings. Well done!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks