What is the syntax to reference a number in a cell using a variable?

Newbie to Excel VB here. I'm making a loop where the integer Row represents the row I'm working on.

For a hypothetical example, I want to take the value of each number in column B and add them together to be displayed in Cell E5 (I know the SUM function would work better, but this is just an example). Here's some psuedocode.

Please Login or Register  to view this content.

}

What's the proper syntax for B|Row?

Hi
select youe cells in column B and run this

Please Login or Register  to view this content.