Excel Visual Basic

Hi Xavier

In Excel it is possible to name Ranges so when you refer to a range in VBA you do so using a string:

If you had named "A1" as "VAT" then in the VBA code you could either write

Range("A1") Or Range("VAT") as they would refer to the same cell

When using the Cells, this refers to the numeric co-ordinates of the cell's position on the worksheet

Cells(Row , Column)

So that Range ("A1") is Row 1, Column 1 which gives us

Cells (1,1)

Hope this helps

Carlos