In Sheet1.Range("A1:A10") I have the results of formulas. Some of the cells have values and some, by formula, are equal to blank ("").
I want to copy Sheet1.Range("A1:A10") to Sheet2.Range("A1") but only the cells that don't equal blank. So, if three non-sequential cells in Sheet1.Range("A1:A10") are not equal to blank, they should paste into Sheet2 cells A1, A2 and A3.
Please Login or Register to view this content.
If you are happy with my response please click the * in the lower left of my post.
Try this:
Please Login or Register to view this content.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Hi Scrabtree,
Thanks for the rep for the rep!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks