I have been asked to create the following truth table:

First Column: Arg1; 0, 0, 1,1
Second Column: Arg2; 0,1,0,1
Third Column: And; 0,0,0,1
Fourth Column; 0,1,1,0
These are my instructions:

Both AND and XOR are binary operations, their syntax in the VBA is the following:
Result = Value1 And Value2
Result = Value1 Xor Value2
9. Create new Module in your Excel project. And write 3 procedures in the following way:
a. In main procedure write values of the first two columns (arguments) to a spreadsheet. (You can start your table from any cell.) Call other 2 procedures: one – for calculation of AND column another for calculation of XOR column.
You should pass to these procedures information about the first two columns, number of the first row and which column that procedure should fill-in.
b. For more flexibility of your program create 5 variables: 4 (String variables) are letters of the columns in the spreadsheet, and 1 (Integer) for the first upper row of your table, for example, to refer cell A1:
Letter1=”A”
Number1=1,
then to refer cell A2 you can write ‘Letter1+cstr(Number1+1)’.
These variables you need to pass to the procedures that calculate and fill columns 3 and 4.
c. The layout of your program can be as following:
 
Sub ANDandXOR()
… ‘declaring variables and filling the first two columns
Call AndSub(…)
Call XorSub(…)
End Sub

Call AndSub(


Sub AndSub(…)
… ‘calculating AND function of the values in the first two columns
‘ and writing into spreadsheet
End Sub

Sub XorSub()
… ‘calculating AND function of the values in the first two columns
‘ and writing into spreadsheet
End Sub

Any help would be much appreciated, Thanks.