View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
L. Howard L. Howard is offline
external usenet poster
 
Posts: 852
Default 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