HI, As per the previous comments on this, it essentially is an array formula, that is applied to a range of a cells instead of a single cell. The function DfListHolidays() is designed to return an array, and not a single value. So if you enter the function as usual in a cell, DfListHolidays() still returns an array, and the first element in the array is assigned to the cell. When you drag the formula across, each time DfListHolidays() returns an array and the first element is assigned to the cells. To Avoid this, select the range of cells (where you want the results to appear), Press F2, type in the formula and end the formula by pressing CTRL+SHIFT+ENTER (not only ENTER or CTRL+ENTER). Now the selected cells have all the elements of the result array. In an array formula entered like this, you will not be able to delete a single cell. You need to select the entire range and delete the formula.
Regards Ajit -----Original Message----- From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Yu Sent: Friday, May 01, 2009 2:16 PM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ { } -his is a function? Hi all, I've been programming VBA for around 1 and half years.But this is the first time I encounter this . It is a not a VBA issue.it is a Excel Function i guess. But I have no idea what it is. Here is what it does: Retreive Financial Calendar from a specified date to a specified data via Reuters Excel add-in (Reuter is data provider). Reuters has provided the function already. The Function provided by Reuters is =DfListHolidays ("Country","StartingDate","EndofDate"). Pretty straightforward. For instance,if I wanna know USA financial banking holiday from 2005 to 2010, i just type in =DfListHolidays("USA","2005","2010") The thing is when you type in =DfListHolidays("USA","2005","2010") in one cell, it only shows the first banking holiday. When you drag that formula down ,all cells also show the same date as first cell. BUT... someone else has used {=DfListHolidays ("USA","2005","2010")} in a column. and cells in that column show all banking holidays from 2005 to 2010. My question is what is { } ? How does it work? I have upload the file called "Kalender_ViaReuters.xls" to the group. Thanks for any ideas! Please also email anytime if you are not clear what I mean. Vincent Zheng Denmark --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
