Hello Corey,

Maybe this will help. This is what your macro is doing...

1. Select cell R59 on the active sheet.
2. Set R59's formula = MAX("1:" & "last worksheet's name!" & H51's
value)
3. Select J59 on the active sheet.

When using the MAX worksheet function, if an argument is an array or
reference, only numbers in that array or reference are used. Empty
cells, logical values, or text in the array or reference are ignored.
You don't indicate if your checking a range of cells or an array on the
worksheet, so I can only guess what you're after. Hope this helps.

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=559194