wow... "everyone knowledgeable knows that VBA performs slow when compared to inbuilt Excel functions"
I guess my 18 years and 80,000 lines of VBA code don't qualify as "knowledgeable". Whenever possible, I try to use VBA code because I can get it done faster than inbuilt Excel functions! I have a worksheet with 101,000 rows (currently). I USED to use vlookup to pull data from a sheet that had 12,000 rows. Recalculation would take 10-12 minutes, EVERY TIME. Instead, a simple 22 line macro does the lookup in about 26 SECONDS. so.. does that mean "experience" trumps "knowledge"? Now, if you're referring to making VBA functions that are used similar to cell functions... (by placing =FunctionName() in the cell) well... THEN what "everyone knowledgeable knows" might be true... Hard to say, since I've never bothered to write a VBA function to do something that is already available as an Excel function... Perhaps an experiment is due... But I suppose that's just my opinion. Paul ________________________________ From: anandydr <anand...@gmail.com> To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> Sent: Wed, March 2, 2011 5:10:27 AM Subject: $$Excel-Macros$$ Re: Excel Interview Q & A The Favorited question happens to be "VLOOkUP" for me... on every interview this has been asked. The no of parameters (which is 4) and the last parameter (which is 0/1 or False and True). Next come the way to look up on the left which VLOOKUP can't do.. so INDEX and MATCH functions with OFFSET of course... Next would be advanced filters and then Pivot tables... everyone knowledgeable knows that VBA performs slow when compared to inbuilt Excel functions so questions on Macros have been few and far between... -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
