Hi Ajit, This is so helpful and informative! I really appreciate all the replies from ppl in his forum.
I used a lot of VBA ,but not that much built-function. But now I know a powerful tool Thanks again for everyone Vincent Zheng On Fri, May 1, 2009 at 3:26 PM, Ajit Navre <ajit.na...@gmail.com> wrote: > > 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---