Ok, I know -- ol' Hercules only had to clean up those stables. I'm not so
sure he would have liked this one at all <g!

I have a pair of WBs. The WS columns are laid out differently, and don't
even have consistent names (one of them is rather fond of abbreviations).

I need to copy relevant data from one to the other, and would prefer to do
it one Row's worth at a time. So, for example if I want to copy something
from rngCell(1, 2) of one WB!WS to rngCell(varLastRow, 17) of the other
WB!WS, and at the same time copy rngCell(1, 15) to rng(varLastRow, 9), how do
I go about explaining that to Excel?

If I can get the core format for doing this, I can hack it into submission
for the real world.

TIA!!
--
Dave
Temping with Staffmark
in Rock Hill, SC