Thread: How the heck?
View Single Post
  #7   Report Post  
Old April 8th 08, 03:34 AM posted to microsoft.public.excel.worksheet.functions
BoniM BoniM is offline
external usenet poster
First recorded activity by ExcelBanter: Jan 2007
Posts: 353
Default How the heck?

You're very welcome... it's refreshing to hear from people who want to
understand instead of just wanting it done!

"Dave" wrote:

Yes, thank-you. I like to understand what I use. Thanks for taking the effort.

"BoniM" wrote:

The Cell function returns information about the given cell, if the info type
(first argument) of filename is requested, the returned info is the complete
path to that cell - for example:

The Find function is looking for the first instance of a right square
bracket in the filename info, which indicates the end of the workbook name,
and returns its character position

The Mid function is therefore taking the location of the ] in the path to
the current cell, and starting in the next position, returning up to the next
255 characters, which will be your sheetname.

Does that help?

"Dave" wrote:

Could someone please explain to me how the following function works?


Many thanks - Dave.