Excel VBA to select every two cells out of a large range : <p>Trying to merge every 2 cells out of a large range. My range of cells is B2:ABC2 currently but will be more before too long (each day of the year). I am looking to merge every two cells so B2&amp;C2 will be merged, D2&amp;E2 will be merged and so on. Is there an easy way to code this to select every two cells from the range and merge them? Everytime I've played with it it just seems to merge the whole range into one. </p>
