I'm working on this sheet and i'd like to copy information from row "i,i", insert a new row below it and copy that information to the new empty row.
I'm working on this sheet and i'd like to copy information from row "i,i", insert a new row below it and copy that information to the new empty row.
Last edited by Tokumoto; 05-19-2009 at 04:53 PM.
Hello Tokumoto,
Bienvenido! or Irasshaimase!
The Range "I:I" is a column, not a row. Where is the information to be copied?i'd like to copy information from row "i,i", insert a new row below it and copy that information to the new empty row.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
This is the code the macro recorder made when I tried manually.
What I want is to select a cell in the A column and insert black row, then copy the information from the row over the empty one.Please Login or Register to view this content.
The excel workbook is uploaded in this post.
Hello Tokumoto,
Did you mean Blank or Black?
What I want is to select a cell in the A column and insert black row
Sorry, mistyped.... it meant BLANK
Hello Tokumoto,
This will copy the entire row of the selected cell, inserts a row, and copy the original contents into the new row.
Please Login or Register to view this content.
Thanks a lot, it worked wonders
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks