PDA

View Full Version : Solved: MaxRow . . . Where Is It Defined??



Cyberdude
11-27-2008, 09:52 AM
I ran across an old macro that contains this single line:

Application.GoTo Worksheets("ABC").Range("FK" & MaxRow)

"MaxRow" apparently is the highest row number available. My question is: where is "MaxRow" defined? I can't find it in Help. It works, but I would feel more comfortable using it if I could find it documented somewhere.

georgiboy
11-27-2008, 09:59 AM
Doesent work for me, are you sure its not defined somewhere in the macro?

i would use...
Application.GoTo Worksheets("ABC").Range("FK" & Worksheets("ABC").Range("A:A").Cells.Count)
as i can see what its doing.

Bob Phillips
11-27-2008, 10:31 AM
It sounds like it is a function somewhere that calculates what that row is. Select that name and then do F2.

Cyberdude
11-27-2008, 11:02 AM
As I said, I found "MaxRow" in a very old macro. I just found the macro "MaxRow" in my Personal.xls workbook. I never use it anywhere, so I had forgotten I had written it. This is the MaxRow code:
Function MaxRow() As Long '10/20/05
Application.Volatile (False)
MaxRow = Cells(Rows.Count, "A").Row
End Function 'MaxRow' Why would I write a macro to contain one code line?? (Ugh!) I dunno.

Thanx for the replies, gang! :bug: