View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] nick.hewett@ntlworld.com is offline
external usenet poster
 
Posts: 5
Default Referencing an External Sheet without Knowing its Name - XL2K

Hello World,

Is it possible, either through VBA or a formula, to check the value of
cell in a closed workbook if you don't know the sheet name?

All I know is that it will always be the first and probably only sheet
in the Workbook.

Kind regards,
Nick.