When I compile the first routine, I get a run-time error 1004: "Method
'Union' of object '_Application' failed." This is puzzling because your
syntax matches exactly that offered by the VBA Help screens. I tried
altering the range descriptions to "Range(ItemRng), Range(StepRng),
Range(TaskRng)" with and without quotes but no go. Could there be a
problem with the value of TaskRng as it gets assigned values?

Also, the assumption that there is only one task for a given date would
make life easier, but would hardly keep us in business. :P Ultimately
this tool is going to be used to merge over a hundred single-task
worksheets into a tracking master list, and then that master list will
be broken up into daily or weekly chunks to help forecast our workload.

I'm working out the method of adding multiple items to a cell, but for
purposes of a clear display, how does one (through VBA) add items to a
cell separated by an internal cell line break?