In the Dummy workbook attached, A1 in this post would be B16 in excel, and A2, B19.
Sheet1: I've un-merged the cells in A2 but the code still doesn't work, the same error pops up.
Sheet2: I would think A1 is the problem then, and tried un-merging it. Still doesn't work. Same pop up error.
Due to other cells, I would prefer if A1 remains merged. And that if you got any alternatives suggestions, it does not involve changing column width.
Last edited by YW3; 05-22-2017 at 08:25 PM.
|