I am trying to a use array to copy all rows to a new sheet if a cell is not blank.
I know there are other methods to do this but was trying to get a better hand with arrays but am failing here
Right now the code copies the header row multiple times and moves all the content
Thanks for any help or insight
Please Login or Register to view this content.
myArray is copied until the end of the loop. What do you want to happen?
Hello AB33, I want to copy only rows to sheet "XXX" where cells in column D of sheet "NodeFiles" are NOT blank
I add a sheet to Book1 to show what I am after
Thank you
Hello capson,
You're macro needed a few changes. The main one was you were not testing if the cell in column "D" was empty. You had equals when you meant not equals.
The second was you were failing to extract just the single row from the array. I have made the code changes needed so your macro functions correctly. If you have any questions, just ask me.
Please Login or Register to view this content.
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 Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Try the attached.
AB33, Thank you
Leith Ross, Thank you
Both solutions work beautifully, I will study them both as the are slightly different.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks