Your use of Cells(x,y) is as good a way as any.

As for working through rows without the user having to select them all
first, you can do that also. First step is to determine a column that will
always have some entry in a cell in it in the last used row. For this
example we'll assume it is column B. Then you can use this as your FOR
statement:

For RowCount = 3 To _
Range("B" & Rows.Count).End(xlUp).Row



"Isis" wrote:

"Bob Phillips" wrote in
:

Bob,

Using;

For RowCount = 3 To Selection.Rows.Count ' Start at Row 3

I can loop through selected Rows - Can I just loop through ALL the Rows
that exist (starting at Row 3) ? so the user does not have to select the
rows first ?

Thanks

PS - I think I have found that Cells.(x,y) seems to reference individual
cells as per my last question ? Is this the best way.

Thanks again