Dear Team,
I have made the macro. But it runs only one time and it is stopping. I am very sure that we have to use some decision making tool but not able to do and succeed. Please find the attached file and below code.
Please Login or Register to view this content.
You have not specified any loop, hence its doing it only once.
Maybe if you explain what you are trying to accomplish, it will make it easier for us to help you.
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]
Hi,
Thanks for reply. In the data sheet, Eg for row:It has to copy the data between B599 to I599 after that it has to paste at AH598:AO598. Later, Entire 599 row has to be deleted.Like that it has to do for 601,603....where ever data corrupted.
You mean every alternate row should be copied one row higher in columns AH:AO?
Yes u are right but only where data is crushed and gone to next line. till 597 rows, data came from apps correct. After that one row been added and AH598:AO598 Cells moved to next line at 599. this way, some cells will be moved to next line.
Last edited by theprincesunil; 12-05-2012 at 12:55 PM.
For easy reference,
I intially write the below code
Please Login or Register to view this content.
Try this code - I have specified that it should start from row 599. You can change that if your real data has some other row with the misplaced info -
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks