Insert Rows between unlkike cells, copy paste, then delete

**am_hawk** · 10-21-2013, 01:38 PM

Copy of Resource Allocation.xls Name_Sort.xlsHi There, I have created a small example of what I would like to achieve, see Name_Sort code below or the attached workbook. My question is, why does it not work whem implemented in "Copy of Resource Allocation", code below also attached. I just do not understand where my problem in Resource Allocation is. There seems to be an issue with inserting and removing the rows but I do not see why. I appreciate the time taken to look at the code I know there is a lot.

Name_Sort:

Please Login or Register  to view this content.

Copy of Resource Allocation:

Please Login or Register  to view this content.

**am_hawk** · 10-21-2013, 02:08 PM

I now understand that it is inserting a row after the last cell with data in it. If you put the letter A down columb B past where the names end you will see what happens. How can I have the macro stop at the last cell with text as opposed to do until ""? I tried using variables but that did not work out it just went all the way to the bottom of the sheet and the inserted rows were still the same as before...

**JOHN H. DAVIS** · 10-21-2013, 02:11 PM

I don't see the attachment.

**JOHN H. DAVIS** · 10-21-2013, 02:13 PM

Originally Posted by am_hawk

I now understand that it is inserting a row after the last cell with data in it. If you put the letter A down columb B past where the names end you will see what happens. How can I have the macro stop at the last cell with text as opposed to do until ""? I tried using variables but that did not work out it just went all the way to the bottom of the sheet and the inserted rows were still the same as before...

To select the last cell with data in Column A

Please Login or Register  to view this content.

Insert Rows between unlkike cells, copy paste, then delete

LinkBack

Thread Tools

Rate This Thread

Display

Insert Rows between unlkike cells, copy paste, then delete

Re: Insert Rows between unlkike cells, copy paste, then delete

Re: Insert Rows between unlkike cells, copy paste, then delete

Re: Insert Rows between unlkike cells, copy paste, then delete

Thread Information

Users Browsing this Thread

Similar Threads

Copy Paste the Missing Values in a Specified Cells and Insert the Rows into a Report

Macro to Copy Values, Insert Row, Paste in Another, Delete Original Data

Excel Macro to insert two rows based on condition and copy and paste multiple cells

[SOLVED] Copy, paste and insert new rows into new sheets

Copy and paste insert rows with protected cells in protected worksheet

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions