Cells.count

[Tucker2008]

Can somebody please explain what this is doing is layman's terms?

Cells(Rows.Count, PageUp.Column).End(xlUp)

 

[Trebor76]

As it is - nothing as there's a syntax error with it.

What do you want it to do?

 

[Tucker2008]

Sorry "PageUp" is a variable that = Cell "C2"...

 

[Trebor76]

What value is in C2?

 

[Norie]

It looks like the code is being used to find the last row of data in the same column that the range PageUp is in.

It does that by going to the very last cell in the column and moving up, just like if you were to use END+UP ARROW from the bottom row.


However there must be more to it, perhaps something like this.

LastRow = Cells(Rows.Count, PageUp.Column).End(xlUp).Row

 

[Trebor76]

Thanks Norie. I was going to say it was to return the last row in a particular column but wanted to see what the value in cell C2 was first. Without knowing what was being assigned to the PageUp variable your code could return an error too.

Tucker2008 - to find the last row in Col A you could use this:

Option Explicit
Sub Macro1()

    Dim LastRow As Long

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

End Sub

Does that help?

Robert

 

[Tucker2008]

Robert,

That is perfect, thank you.

 

[Trebor76]

Thanks for letting us know and you're welcome