Can't get last row number to work.

[Guest]

Forgive me for overlooking what I'm sure is obvious, but I'm completely stuck
(and more than a little frustrated). I am referencing data between
worksheets, so if my Dynamic range on sheet "A" ends on row 391, that is the
number I want to show up in sheet "B" (just the row number, not the column).

The following works, but it attaches the column number to the final info
=ADDRESS(MAX(IF(MyRange=MAX(MyRange),ROW(MyRange)*(MyRange<>""))),COLUMN(MyRange),4)

Previous posts for the same question showed formulas such as: lastRowNo =
Range("A65536").End(xlUp).Row
and
Cells(Rows.Count,"A").End(xlUp).Row
but it never works for me. (It says there is a problem with the forumla and
highligts the word "end"). I can only assume I'm looking at this to
literally, and something needs to be entered differently. Is this a formula,
a function, or a macro? How does this actually get entered?

thank you!!

 

[Carim]

Hi,

Give a try to the following :

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

HTH
Cheers
Carim

 

[Guest]

=SUMPRODUCT( MAX( ROW( MyRange ) * ( MyRange<> "" ) ) )