| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Reusing formula | Excel Discussion (Misc queries) | |||
| Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
| Locking portions of a formula | Excel Worksheet Functions | |||
| assign formula to another cell | Excel Worksheet Functions | |||
| Match then lookup | Excel Worksheet Functions | |||
Linear Mode
