|
<< Click to Display Table of Contents >> Pairs.AddPair Method |
  
|
|
<< Click to Display Table of Contents >> Pairs.AddPair Method |
|
Adds a pair to the Pairs collection.
expression.AddPair(Sheet0,Sheet1,Range0,Range1,DBoptions,WSoptions,DBrow,DBkeys)
expression. A variable representing a Pairs object.
Name |
Type |
Description |
Sheet0 |
String |
A worksheet name of the source file. |
Sheet1 |
String |
A worksheet name of the target file. |
Range0 |
String |
A range address of the source worksheet. |
Range1 |
String |
A range address of the target worksheet. |
DBOptions |
If the worksheet is a database, enter database options here. |
|
WSoptions |
If the worksheet should be linked 1 on 1, enter linking options. |
|
DBRow |
Long |
If database comparison, enter row with database column/field names. |
DBKeys |
String |
If database comparison, enter the column number(s) which contain(s) the primary key(s). Separate numbers by semicolon(s). |
Returns a Pair object