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:
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.