I have the following VBA code in which I am identifying the number of rows in
a workbook named "FileOpenNameLast." This name includes the full path of the
workbook and, therefore, my code deosn't work. Isn't there a simple way to
refer to the workbook name in my code?

NumRowsF832 =
Workbooks(FileOpenNameLast).Name.Sheets(1).Range(" A65536").End(xlUp).Row



--
Ken Hudson