Thank you, very much. Obviously, I missed the forest for the trees in front of me. That worked (specifying "" to close out the full syntax), but I still have now blank spaces to deal with, vice the "FALSE" values I had before your suggestion. I knew about the last variable, I just didn't originally think I needed it. At least I'm now a step closer to where I need to be.
Now, it is converting the merged cells into now blank cells. How do I get the target sheet to auto sort the blank cells out now, to make the final product idiot-proof for my users?
|