Select the macro in the window's Project box that you want to read Excel's data. Type the following line of code:Dim contents As IntegerThis declares a variable to store the cell's data.