Ranges of cells in VBA

[cultavix]

I am trying to understand how to make reference to different cells from VBA. Here is some example code of a range of cells.

Please Login or Register  to view this content.

Does this refer to Column A and Row 1 ?

Thank you

(note: i didnt put the code in the code brackets because its just one line)

[royUK]

You should always use Code Tags.

The range in the code is A1, because you haven't specified a sheet it will be on the activesheet. Although the use of .Cells should indicate you are3 using a With statement