Combine three InputBoxes into one?
Great stuff indeed.
I assume this converts the column letter/s to a column number and also convers lower case entries to upper case so they will work with the code?
SourceCol = Columns(UCase(arrInfo(1))).Column
TargetCol = Columns(UCase(arrInfo(2))).Column
Thank again.
Howard
|