anyone ever hear of a formula beginning "xlend"?

E

excelmix

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?
 
C

ChristopherTri

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

Good luck...
 
K

Ken Johnson

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

Good luck...
Click to expand...

Copied from the Object Browser...

Const xlEnd = 2
Member of Excel.XlChartPicturePlacement

Ken Johnson
 
D

Dave F

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
 
Top