Search for empty cells and move cells next to
However, the suggestion from Claus Busch worked perfectly, so
my problem is solved. Thank you for trying to help.
Great... I am glad Claus was able to figure out what you were looking for.
On a side matter, yesterday you started a thread entitled...
"Find and move cells with text"
I am not sure if you have gone back to that thread recently or not, but I
posted a non-looping solution to your question that I thought you might find
interesting.
Rick Rothstein (MVP - Excel)
|