anyone ever hear of a formula beginning "xlend"?
 

I have a complex workbook, with multiple linked tabs. One set of formulas
read =xlend(name of tab!cell,-4111)
the referenced cell is a date cell, but the result has nothing to do with
dates and seems appropriate to the subject. I can't figure out how we get
from a to c and the online reference and knowledge base return 0 documents.

Anyone got a clue?

anyone ever hear of a formula beginning "xlend"?
 

Might be a user defined function. Launch the visual basic editor and search
throught any modules attached to the worksheet.

Good luck...



"excelmix" wrote:

I have a complex workbook, with multiple linked tabs. One set of formulas
read =xlend(name of tab!cell,-4111)
the referenced cell is a date cell, but the result has nothing to do with
dates and seems appropriate to the subject. I can't figure out how we get
from a to c and the online reference and knowledge base return 0 documents.

Anyone got a clue?

anyone ever hear of a formula beginning "xlend"?
 

ChristopherTri wrote:
Might be a user defined function. Launch the visual basic editor and search
throught any modules attached to the worksheet.

Good luck...



"excelmix" wrote:

I have a complex workbook, with multiple linked tabs. One set of formulas
read =xlend(name of tab!cell,-4111)
the referenced cell is a date cell, but the result has nothing to do with
dates and seems appropriate to the subject. I can't figure out how we get
from a to c and the online reference and knowledge base return 0 documents.

Anyone got a clue?

Copied from the Object Browser...

Const xlEnd = 2
Member of Excel.XlChartPicturePlacement

Ken Johnson

anyone ever hear of a formula beginning "xlend"?
 

Could be a user-defined function. Have you checked the VBA code to see if
there are any UDFs? If you don't know how to do that, right-click on one of
the tab names, select view code, and see if there is any code. If there is,
paste it to this post and someone can explain to you what is going on.

Dave
--
Brevity is the soul of wit.


"excelmix" wrote:

I have a complex workbook, with multiple linked tabs. One set of formulas
read =xlend(name of tab!cell,-4111)
the referenced cell is a date cell, but the result has nothing to do with
dates and seems appropriate to the subject. I can't figure out how we get
from a to c and the online reference and knowledge base return 0 documents.

Anyone got a clue?