Changing Column values with VB code

LastRow = Cells(Rows.Count, "A").End(xlUp).Row

I am struggling with this code, can you tie it to the code so maybe I can see the big picture...,

I like the dynamic ranges, it makes data entry more efficient, ...trying to overcome my volitle issues, I have begun to read up on volitle isses, but I find myself a bit overwhelmed as I think everything I do is "Volatile", maybe that is my self-destructive behaviour showing itself in the form of excel...lol

But I regress, I have faith, I will get there, with lots of help

I use the

LastRow = Cells(Rows.Count, "A").End(xlUp).Row

Most every time I write code now.

LastRow is a variable name I have Dim above
Rows.Count is the maximum number of rows in this version of Excel - Way down at the bottom.
Cells ( Row, Column) specifies a range you want to start in.
"A" is the column you are wanting
.End(xlUp) is the same as pressing Ctrl-UpArrow to hit the next non blank above
.Row returns what row was found.

So in English this says
Go to the very last row in my worksheet at Column "A" and press Ctrl-Up and tell me what Row it stopped in. Let the variable LastRow equal to that number.

Read http://www.mvps.org/dmcritchie/excel/cells.htm
http://msdn.microsoft.com/en-us/libr...ffice.11).aspx
http://spreadsheetpage.com/index.php...e_size_ranges/ I like this site.