LinkBack URL
About LinkBacks
I would like to only copy data when the cell in Column i is not empty. I'm still learning and would welcome any pointers if there are any blantent errors in my code.
Thank you in advance. John
Please Login or Register to view this content.
Help needed with loop and copy if cell not empty
I would like to only copy data when the cell in Column i is not empty. I'm still learning and would welcome any pointers if there are any blantent errors in my code.
Thank you in advance. John
Please Login or Register to view this content.
Maybe this:
Please Login or Register to view this content.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
That works thank you! I have tried to speed up the code to no avail, do you have any ideas
Please Login or Register to view this content.
At the top of the macro:
At the bottom:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks