How can I find the last cell in a closed workbook?

Joined
Jul 30, 2006
Messages
3,656
How can I find the last cell in a closed workbook?

My research has not found anything current.

Thanks in advance.

Have a great day,
Stan
 

Some videos you may like

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
54,843
Office Version
  1. 365
Platform
  1. Windows
Is there some reason you do not want to open it? Is it possible to have your macro open the workbook, find the last cell, then close the workbook automatically?
 

Watch MrExcel Video

Forum statistics

Threads
1,113,862
Messages
5,544,727
Members
410,630
Latest member
JFORTH97
Top