Microsoft Excel - Visual Basic for Applications Consultant   PROFESSIONAL SOFTWARE DEVELOPMENT Reliable Excel VBA Solutions !

dropdown list in cell     mult-criteria text lookup     spreadsheet bloat     more ...     if...then[...else]     what are variables ?     dynamic arrays     more ...     dynamic named ranges     finding real last cell     charting dynamic data     more ...     amortization guide     breakeven analysis     standard deviation     weighted average     excel vba customization     professional experience     project request form     engineering analysis     financial reporting     sales forecasting     automated billing     engineering design     clients - past & present     gratuitous kudos         e-mail contact 20831 Rosehill Church Rd Tomball, Texas 77377 Visitors' Comments Beyond Technology - Gratuitous Mail So many kind notes come from thoughtful people who to take a minute of their valuable time to send a friendly message. Here are some of them, so you know - It's REALLY appreciated. To drop a 'pearl' of your own, send a quick e-mail to rodney@beyondtechnology.com.   Rodney, ... Thanks for your help! - Kevin Cunningham [Compass Bank]   Rodney, I’ve used your site and it’s examples for clues to my projects for years. The site is laid out beautifully; it is clean, and concise. ... Thanks - Mark Trevithick,   Last Excel Row - Thanks! You rock. - Bill   Thank you! Thank you! Thank you! I've been searching for this technique for years (being a reasonably clever Excel hack but hardly an MVP). I just knew there had to be a better way than the xlUp from the bottom, which requires knowing the longest column or testing all of them in the known column-range. Very much appreciated! Regards, - Peter Straton [Symantec]   are awesome this saved my life =OFFSET(MySheet!$A$1,0,0,COUNTA(MySheet!$A:$A),1) THANK YOU - Steve Brooks   Howdy, Great web site. I really appreciate the clear and logical way you explain how functions, formula’s etc are processing their logical steps. I wish Microsoft help was as clear and effective as yours. ... Have you written any books? There are lots of great ideas out there on the net. Sample formula's, user defined functions etc. the issue with most of them is they are difficult to decipher for the layman. You do a great job of that. You may consider writing a book or even hunting for the great techniques, then posting them on your site with your clear and plain way of explaining what is going on. - John Engelmann [U.S. Air Force - contractor]   Rodney, I was reading your site and it is a great help to so many people . Thank you. - Travis Weaver   Rodney: I am nowhere near the Excel guru that you or Bob Umlas or John Walkenbach or Chip Pearson can claim to be. I am the Excel go-to guy for my office. And I couldn’t have done my latest critical project without your help. Thank you for the "Identifying the Real Last Cell" tip. Best wishes, - Geoff Lilley [Pearson] Sacramento, CA   Hi Rodney, Your article on shrinking spreadsheet bloat was fantastic and VERY helpful. - VL Vawter   Hey, I just checked your site. It is good. You have described the things very well. Regards, - Ravi Sagar India   Rodney, Just a quick thanks - nice site. - Cam Howie [Lake Erie Steel Works] Canada   EXCELLENT Thank you, - Mark Stinson [Lockheed Martin]   Rodney, I stumbled across your geat Excel tips and techniques and found at least two formulas that will help me. - Mike Connolly Phoenix, AZ   I am writing you, first of all, to thank you for teaching me through your Web site to work with VBA for Excel. I've been developing an application of post processing data from reports of Power Quality and, even without knowing each other, your knowledge was very helpful for me and my workmates. Sincerely, - Igot Ferreira Visconti Brazil   Rodney-- Fantastic job with the site ... I've been using it for two weeks and it has really, really added to my knowledge of Excel and VBA ... Anyway, keep it up. - Nat Arem   Hello Rodney, I was looking at your examples that you provided and they are very helpful ... Much Thanks! - Erika Ramirez [U.S. Department of Agriculture]   Rodney, Great site. It has been very helpful. - Andy Male   You gave the answer when the MS Help gave nothing - THANKS! - Marjorie Kolkin [Compass Systems & Programming] Exeter, NH   Good morning! Your site is very professional and the content you provide gratis is useful even to advanced Excel users. - Paul Gillespie   I stumbled upon your web site and find it useful. - David Cramton   I have been avoiding performing standard deviation analysis for years. Your advise has greatly helped me understand the process. Thanks. - Debra Gardner   Hi Rodney, ... I had found your site when searching through Yahoo ... the site is very well laid out and helpful. - Bob Gowens   Rodney, ... Thanks for the web page. I found it very helpful. - Guang Tong   Hi Rodney I am now using the drop down list you described on your site. Thanks for that. ... Cheers, - Iain Smith United Kingdom   Rodney, Randy Hayes and ExxonMobil - just wanted to say thanks again for the e-mail list of possible MS Access assistance. I've placed the e-mail in ExxonMobil's database folder. For now we are waiting for the IT department to decide what they are going to do (or not be capable of doing). Anyway, I greatly appreciate your help yesterday. Best Regards, - Randy Hayes [Kellog Brown & Root] Houston, TX   Hi Rodney, I'm enjoying your website with all the spreadsheet formulas ... Thanks for your help, - Anthony   Hi my name is Thomson and I found the tips on your Excel sheet very interesting. - Thomson Mathews   Hello Rodney: I've enjoyed your helpful hints and tips ... - Gerry Fitzgerald [Halliburton]   Thanks for the magnificent tip of dynamic validation list ranges ! I was searching for this for years and finally I have it now. ... thanks: - Ivan Fenyves Johannesburg, South Africa   Hi there, I was interested in your little article related to Dynamic Named Ranges, which leads me to ... Cheers, - Jim Carter Australia   Rodney, Thank you for your web site. I love it. Not only is it relevant, but it presents the topics within context!! This is a tremendous time saver and where the real learning takes place. - David DeLancey   Thank you so much for this information!! Love this web site. I really need to understand VB and this website has been great fun!! and useful. I just need all kinds of tips. Generally, I'm new at VB and trying desparately to use it for data collection work. ... I like your website ... it's been very helpful to me. - Joan Sibbitt [Motorola]   Hi Rodney, Love your website! ... - Lindy WIlliams [Vodafone] Australia   Your website has been of greate help. I was delighted to find your charting procedures for dynamic data ... Thank you, - David Noto   Dear Experts, ... This is such a great website ... - Sue   I must begin by saying your Tips make my Internet browsing worthwhile. Keep up the good work. I promise to keep you in mind for any future projects, etc. - Ravi Korlahalli [ANCA Pty Ltd.] Australia   Rodney, Your 'power tips' have been a lifesaver for me. I found your website through a link in the Microsoft Office web page and have already found answers to two frustrating problems I've had. Thanks for this service, it has truly been helpful. - Starla Vigil   I was looking online for an anwer to an Excel question and came across your site. Very impressive! - Richard Murray [Carrier Sales]   I am a management consultant for a Swiss company. Your web site tip on converting dates to quarters was very helpful and well written. We appreciate it! Many Thanks, - Neal Mueller   Rodney, Thanks for your vast pool of wisdom and rapid response to my plea for help. You came through for me with your solution to my problem ... - Mark Usher [Global Technologies, Inc.]   Greetings, I just wanted to say thank you for the wonderful Excel help site. I spent over a day looking for Excel help on the Web and then I came across your site, which is a godsend. I've been through the "spreadsheet power tips" and "getting to know VBA" and I'm into the "for geeks only" section now. Thanks Again, - Natasha Drake [Chaucer Digital]   I visited the Beyond Technology web site and found it to be extremely helpful. I've been using the power user tip that allows you to reference the most recent entry in a list ... ... Also, aside from what is offered free on the website, does Beyond Technology offer any courses or manuals that would teach me VBA ? - Chris Hudson   I happened to see your site accidentally. A quite informative one, especially on VBA. Could you please add me in your mailing list for tips on Excel. - Balaji Ranganathan   Rodney, Your web site is excellent. - Trevor McCarthy [BP Amoco] Queensland, Australia   Thank You for your help. ... Again thanks for your help. I learned something useful. - Rick Parkinson   Thank you and great website. I can't wait to actually use some of the information (I just discovered the site today!) - Kenn Sturgis [K Hovnanian Mortgage, Inc.]   Strong Work Really nice website. Great tips, clean design, easy navigation. Thank you for the time and energy you put into this site. - Scott Davis   Neat interface. I have gotten a book about making stuff with Microsoft Agent and had hoped to go into business. Your interface is the most developed I have seen (you use the correct gestures in the correct contexts, etc.) Not that I am an expert or anything! Anyway, it would be good if you would make Peedy a real interface, like allowing me to navigate the site with him... Good job! P.S. Could you e-mail me if you update it? I would like that! Thanks! - Shawn Boles   Rodney - I appreciated your dynamic named range explanation ... - Jim Shoenfelt [AmTrust Services]   Rodney: First, I'd like to express my thanks for your clear explanation on how to apply drop down list boxes into Excel. It's been a great help for me. It's a source of pride to find out you are a neighbor, living right down the street in Spring - Klein area here in Harris County. ... Thank you for your kind attention. - Art Montemayor Spring, TX   Rodney I really appreciate what you have done with your website. I wish you would write a book. Until today, only John Walkenbach could write so I could easily understand. Thanks - John Augustein   I stumbled onto your site and I think it is awesome!! - Paul O'Connor Canada   Thanks for the wonderful tips on using array formulas. - Carol Maharaj [Litton]   Thank you, thank you, thank you!!! I've looked high and low for a way to easily compare lists!!! And there it was on your page in simple English. Great site; definitely bookmarked for me now!!! - Tracey Peck [DigiScript, Inc.]   Hey, You probably receive thousands of that type of mail every day, but still ... I recently took on VBA for Excel on my own, so just wanted to tell you that your site is by far: 1. the most comprehensive 2. the most useful in terms of tips and tricks 3. the best laid-out and neat and ergonomical 4. the most professional-looking (well, not surprising...) Way to go! It definitely gave me new food for thought as far as career aspirations go. - Vladimir Popov Australia   Rodney, I read your solution to charting dynamic data and found it very interesting. ... Thanks, - Paul Watson   My boss came to me this morning and asked for a row of weighted averages. I had never done this before, so how happy I was to find your site immediately and within 10 minutes I had the whole spreadsheet ready for print-out. Thank you for being there and for being so clear and easy to understand. - Mary Morrison   I was looking for a way to find the used range in an Excel sheet. Your example worked perfectly. - Steven Martino [American Financial Systems, Inc.]   Hi Rodney, First, I must really commend you for your site provides some of the most valuable tips to Excel fanatics like myself. Thank you for that! ... Many many thanks! - Ace Eagle   Rodney, I am a regular visitor of your website. I like if very much, My Excel capabilities have been growing as a result of that. - Gerard Thijssen [KEMA T&D Consulting] The Netherlands   Dear Rodney, You are a blessing to the millions of people searching for Excel solutions, I enjoy your site very much. The presentation is great with least download problems. Keep up the good work!! ... Thank you once again for the great tips on EXCEL POWER. Best Regards - Vino Joseph [TotalFinaElf] Dubai   Hi Rodney, I visited your site and I am quite impressed ... - Greg McDonald [Ingersoll-Rand] Huntersville, NC   Your clear explanation is much appreciated! Do you have similar livesavers for Access? - Jane Hunter   Thank you for the Excel tip on preventing duplicate entries. ... a nice simple solution that will help me with some inventory control. - Brian Fisher   ... I found your web page and what great information ... - Gerri Johnson   How about class modules for mere mortals? Just a suggestion. Enjoy your tips. Cheers, - David Phares [Borland]   Hi Rodney. I appreciated the newsletter and all the highly useful information you hand out freely on the web site. I've gotten a lot of mileage out of it. I just received the November newsletter this a.m. and read the article about using the list/validation drop-downs. I have gotten a ton of use out of that feature. - Curt Smith [Black & Veatch] Orlando, Florida   I was looking at your site and see that it has a lot of very useful information ... - Dean Sandvig [Kimberly-Clark Corporation]   I use several named ranges in a workbook that I use for scheduling at work. These ranges change constantly due to new orders being added and old orders being closed. This required me to be diligent and continually make certain that the ranges were correct. If others made changes to the sheets, they would invariably become invalid. I have made every named range a dynamically named range now which will save me hours of work. I have additionally put the last cell code to work in my modules with great success. Great site with excellent code samples. Thank you for sharing! - Mark Trevithick   RE: Standard Deviation in Excel Spreadsheets I was stuck looking for the correct formula (procedure) to duplicate the Excel StDev formula. We're migrating some things from Excel to VB that required it. Your document explained it quickly and completely. Thanks a million, - Mary Whittington [ADN]   Excellent newsletter. Please keep it coming. I send referrals to my students. ... - Kimberly Mills [Aries Training Associates]   Hello: I have been just recentyl introduced to this site and already have learned a great deal. Keep up the good work. ... - anonymous   I stumbled on to your web site by accident. I needed to know how to calculate a weighted average. Your example was easy to use and was very helpful. Thank you for providing such helpful information. Keep up the good work. - Mark Perez   First of i am very thankful to you. I am very pleased to see your site. It helps the people to a great extent. ... - Hashmat Kakajee   First of all thanks for some great tips, I've found lots of handy things on the site. ... - Raoul Federman [Heron Corporation] London, UK   I have visited your site several times and I think it's very usefull for me, because I've learned a lot of things. ... Saludos!!! - Adrián Cerda Rodríguez [Frito Lay] Monterrey, México   Thanks Rodney, I do not know a better way but just wanted to write to say thank you. Your tip on cleaning up the ActiveSheet.UsedRange enabled me to shrink my "have a cup of tea while the spreadsheet opens" 13 GB spreadsheet in half. Have a good day. - John Slobodnik   ... I do want to thank you for the great resourceful website. Best Regards, - Yee-Bien "Aimee" Chuah [David Weekley Homes]   Did a great job of explaining the drop down list. ... - Bill Vidacovich   Hello Rodney. I have picked up very useful tips from your website. Many thanks. ... - Chuck Harkes   ... I did look through your site and really like the information that you provide! ... - Joe Witte [PG&E National Energy Group]   Congratulations for the web site : design and content are equally outstanding. Regards from beautiful Belgium, - Hervé Hanuise [Affordable Solutions] Belgium   Hi there - I am hoping that you may be able to assist me. I am sure you can as I have often found that Beyond Tech is the best Excel resource out there. - Matthew Maule   Firstly, may I say congratulations on your site - it contains may useful tips. ... - Ananda Gunasekera Australia   Dear Mr. Powell, Thank you very much for your kind help with my Excel VBA problem. I will use your find final cell code. (I am pleased to say I at least had figured out the end xlUp approach.) Also, thanks for the newsletter subscription. I will definitely spread the word. - John G. Scott [Predictive Systems, Inc.] Roswell, GA   Is awesome Thanks for the tip! - Jason Cumberland [KPMG Consulting]   Thanks for providing some great examples of Excel's advanced capabilities!!   Thank you for your updates. ... - Loretta Melnychuk [ExxonMobil]   I love your site. Thank you. Regards & Best Wishes, - Roman Mesina [Windward Capital, LLC]   Rodney, Rodney, your help on adding time values was invaluable to me ... ... Thanks - Kris Wright   Hi Rodney, I would like to thank you for your quick response and very helpful information. It's nice to get feedback from someone in the industry. Thanks again - All the best, - Patrick Murphy   Ladies & Gentlemen, Great site you have there. ... - Russell Williams   Rodney, I love the web site, only found it today but made use of your dynamic named ranges immediately. Thanks VERY MUCH. ... Keep up the good work. - Doug Gaynor [PricewaterhouseCoopers BPO]   Good morning Rodney, Thank you for the tips they prove to be v. handy ... - Karin Wightman   Rodney, Thanks for your Excel tips. Every month I learn at least one thing new. ... - Scott Haralson [America West Airlines]   Hi Rodney, First off, I want to tell you how helpful your newsletter is. Every time it comes out, I seem to find a little tidbit that helps me in my VBA. ... - Kenton Leo   Gentlemen: I had a problem trying to add time values over 24 hours. I consulted several people about the solution to this problem. I even bought a Complete Guide for Excel, without getting the answer. It just took 1 minute to go over your site and found the solution. Please accept my thanks for this wonderful service. Yours very truly, - Sergio A. Rodríguez M. Panamá, Republic of Panamá   Hello: I appreciate your tips on Excel. They have been very useful to me. ... - Doug Gaynor [Carson Oil Company]   Hi, I just wanted to say thank you for your Excel tips. I appreciate the free help very much. Sincerely, - Steven Gravino   ... Keep up the great work. Regards - Alex   Thanks for the quick response. This does work! ... - Dr. Don Scavia NOS Chief Scientist and Director, National Centers for Coastal Ocean Science [National Oceanic and Atmospheric Administration (NOAA)] Silver Spring, Maryland   Thanks. I think I got it. - JR Wehrmeister   Thank you for the updates. - Michael Boyd [ATLIS Systems]   Hello, I get your news letter and enjoy seeing all the cool VB stuff. ... - Peter McAlenney [MFG, Inc.]   Thank you and I look forward to your mail. ... - Dan Sasser [Universal Corporation]   ... love your work - Kitch Morris   Thanks for a good site! Sirs, I have been reading pages from your vba site. it's a good source of reference. Regards, - John Maclean   Great article on a neat feature (dropdown listbox). ... - Vernon Huff   Dear Sir, I have expanded my colleagues' and my knowledge enormously with the help of your tips. Keep up the good work. Thanks from all of us. - Abe Meir   Thank you very much. ... This will be easy now. - John Stec   These tips are useful - the best one was on how to sum a range of cells containing #N/A Many Thanks - Norman Marshal [McKinsey & Company]   Rodney Thank you very much for your prompt reply . It's working for me now and (as you said) it's unbelievably fast. Best Regards, - Alon Othnay [Johnson & Johnson]   Hi Rodney Great code you make for getting data out of closed workbooks. ... Thank you for making this all available to us. - Ron de Bruin   ... Thanks for the info. I'll show your website to my MBA decision support modeling class this spring semester. - Leon Lasden [UT Austin Business School, MSIS] co-author of the Excel Solver   Dear Sir: I have subscribed to your newsletter. It's very useful. I've read "SQL for...." and it's very easy for understanding. Thanks ... - Nancy Godoy   ... I enjoy your newsletters and look forward to more tips. Thanks. - Nick Feller [Feller Consulting] Englewood, Colorado   Thank you for putting together such an information, extremely useful website for Excel and VBA. There is no time at work to go "beyond" the tasks that we use everyday and even though we know there must be a better way - we do not have the luxury of spending the time to figure that better way out. I will keep looking at the great information you are publishing and continue to look beyond the box. - Pat Miltz   Hi Guys Love your useful excel info. ... very much appreciated - Amanda Askew Australia   Hi Rodney. I appreciate the newsletter and all the highly useful information you hand out freely on the web site. I've gotten a lot of mileage out of it. I just received the November newsletter this a.m. and read the article about using the list/validation drop-downs. I have gotten a ton of use out of that feature. ... Regards, - Curt Smith [Black & Veatch] Orlando, Florida   Information on the Beyond Technology site is superb! Compliments. ... Greetings, - Anonymous   Greetings Beyond Technology; Just thought it was time for me to say "Thank You" for your excellent work. I must say I don't remember what I did that got me on your mailing list a year ago or so but I'm glad it happened. I'm not a killer-geek "power user" but I need Excel often enough and I depend on it. You've provided some excellent learning material over the duration. I appreciate it. Best Regards - Kevin Meagher   Hello Mr. Powell, Thank you for your valuable Excel Tips. They are great! ... Thank you for all of your help and a great newsletter. - Claud Moore [Huntsman Corporation] Marysville, Michigan   Excellent Page - Marcos Oyola [PB International]   Hi Rodney, I admire your contributions and the entire site! ... Thanks alot! - Sam ElAssaad Santa Clara, California   [One of the best sites I've come across] Thanks so much for building a site that has more use and meaning with an easy layout and functionality!! - Laurie Hare, B.Sc., MBA, QI   Hi Rodney First of all I would like to thank you for the real good excel tips! they are really useful. ... Regard - Subodh Gupta   Rodney... Like the useful VBA stuff on your site... - R.J. Harrison   I am new to VBA and medium skilled at MS Excel. I have purchased a book recently to learn and increase my knowledge. I have also visited many on-line sites to broaden my education on the issue. I came across your site while browsing and I wanted to let you know it is awesome. I learned more in the half hour I spent at your site than the "numerous" hours I have spent reading books and browsing other sites. Not only did I add your URL to my Favorites, I put the shortcut on my Desktop [Just to let you know, that is considered a great honor in my world :) ]. - Joe McFarland [TeleTech] Denver, Colorado   Great to hear from you again! These tips are always a great help, Thank you. - Timothy Furguson [K2 Corporation]   Dear Rodney First of all let me thank you for the great website you have, it's a great help for people like me who know very little about Excel. ... Thanks - Deepak Ahuja [KFS, Inc.]   Hi! Your SQL for Mere Mortals series has been very helpful! How long do I have to wait for parts 3, 4, 5? Is there any way I can get it in advance? Thanks and keep up the great work!! - Paul Plodzien [General Motors Corporation]   I must admit, I hadn't used this much up 'til now. Your example {Select Case Structure} makes this an obvious choice. Thanks and All the best - Ron Anderson [Comet Group PLC] Hull, England   Thankyou!!! - Charmayne Paul   Figured I'd try out Teoma after seeing some press from C|Net. Let me here, and I'm glad it did. Great resource!! - Dave Aust [Clearwire Technologies]   When searching the net for some help I found it right on this page and much more !! ... great - Roger Van de Craen [FBFC International NV]   Thank You. - Kitt Langkilde [After Hours]   This is a wonderful service. Are back issues available? - James Greene [JimCo]   Heard about this from my college algebra professor who loves Excel and uses it like a wiz. - Joanne Worcester [Law Dept.]   The bit labeled 'geeks only' is probably the most useful bit and something anyone looking to do something a bit more complex should have a look at - not just 'geeks'. - Andrew Fraser [Arup]   This is a very interesting site for me. The way you explain every subject is easy for everyone. It's very useful for me this site. Thanks!!! - Adrian Cerda [Sabritas, S. de R.L. de C.V.]   Thanks for your tips. - Antonio Morales [M Najar, SA]   Great Site - Wade McDowell [Rural Telephone]   In 2 minutes this site helped me solve a function problem I have been working on for weeks at work! Thanks!! - Dorothy Griffin [Patrick Henry Community College]   Great site. I found the answers to questions I had within 5 minutes. The quarters calculation is very handy. - Hamish MacPherson [ANZDL]   Chance find - very impressive - two invaluable tips. - Greg Marsh [Global Freight Exchange]   VERY USEFUL - Vidyapathy Na [Akmit]   I searched for help re: how to start using VBA (in Excel). This site has been VERY helpful. Thanks! - Allan Pentecost [Intel]   The YTD-offset function was very helpful, thanks - Marco Plandsoen [Fenestrae B.V.]   Love your site. Very clean and easy to navigate and the information is superb. Keep it up. - Charlie Price [Guardian Inspection S.A. DE C.V.] Mexico   Found you while surfing -- I think you're wonderful!! - Carol Welch [The Container Store]   I was on your site today an thought that it was great!! Well done! I am an avid user of Excel and know the formulas and functions pretty well. Thanks, - Peter Karaffa   Thanks for such great tips. Congratulations on this quality, well-structured, user-friendly site. Regards, - Al DePalma [W.R. Grace]   Wow, this is great information. Many thanks for having this available. Easy to read and understand - Sheryl Goad   The department I work in had used Lotus 1-2-3 for years. I became proficient at writing macros in Lotus and when we were given Excel I had my doubts, however I have found that Excel is as good if not better. Your site has provided me with many answers that I could not find elsewhere, I appreciate it since I do most of the vba programming for my department. - Bob Smith   Sir, Thank you so much for your tip on the above. I use pivot tables extensively for my reporting and I found your tip on using dynamic ranges for my pivot tables a lifesaver. I requested for tips on updating my pivot tables dynamically but no one provided anything half as simple and easy... Thank you and God bless. - Omar Bafagih   Hi there Web Master I have just visited your site and I am quite impressed with its details and offerings. - Nathan Johnson   Hi Rodney, I like your site. It's well done and helpful ! ... Thanks, - Russ Reimann   Thank you for the tips. I was able to put them to good use immediately. - Elisabeth Snyder [New York Life]   Sir, Thank you so much for your tip on the above. I use pivot tables extensively for my reporting and I found your tip on using dynamic ranges for my pivot tables a lifesaver. I requested for tips on updating my pivot tables dynamically but no one provided anything half as simple and easy... Thank you and God bless. - Omar BafagihUnited Arab Emrites   Hi Rodney Thanks for the tip on ...... Links - Locating Bogus "Ghost" References. Went into the Define Names menu, and there it was staring me in the face! Man that has been bugging me for ages (and my boss every time I send her a copy my spreadsheet to review!). Cool site and cool tips for a HOT day. - Ross PetherickLondon, UK   Dear Rodney, First of all, your site has transformed me from saying "What's a spreadsheet?" to the office excel guru. Thanks! I have found your tip on using the standard deviation function quite helpful, but I need to take it further. ... Sincerely, - Ben Taylor   Hi Rodney, I like your site. It's well done and helpful ! ... Thanks, - Russ Riemann   Have you given any thought to publishing your tips in a PDF? Excellent tips....thanks much for helping us all. - G. Hancock   Your advices are great Thanks - Niko Osolnik   Thanks ! - Jailson Castilo [V.I.]   Thanks for the fast response and the help you and your site help out a lot!!! - Aaron   Thank you - Tamas Becsak [Honeywell Kft]   ... These are wonderful ... - Kara Mullaley [Corning Cable Systems]   Very helpful. - Christina Au [Ngai Hing Color Technology Co., Ltd.]   Site is good! - Badri Srinivasan [Meenakshi Computers Limited]   Dear Rodney, I came about your Web site by accident the other day and was intrigued by the capabilities that were outlined as possible within Excel ... - Colin Lishman   Your pages on Tips, VBA, and Geeks are well done and very helpful. Thank You - Daniel Belisle   Great site - thank you - Monty Wood [Amber Business Computers]   I like your site very much. It's not cluttered like so many (i.e. MSN). ... - Charlie White [ELI Inc]   The online tips are great. I'm looking into VBA as a new hobby/career development interest. Thank you. - Curtis Childers [Agribuys]   Thanks Rodney, for your clear, step-by-step explanation of the Standard Deviation formula process. I did a search on the subject and found several discussions, but NONE as clear and unassuming as yours. Thanks for the help in time of need. - Charlie Michigan   Wow I wish I would've checked out this sight earlier, instead of sitting around for an entire day trying to develop my own dynamic range. ... In other words excellent website! - Carman DecellesCanada   You've got some really good ideas there. - Murray Clark   The tips were very helpful so far on a complicated project for one of my clients. Thank you. - Tony Worley [Computer Consulting] McAllen, TX   This site is exceptional. I am interested in developing applications for consolidation of financial statements in the future and I'm positive with your tips I'll achieve my goal. - Peter Lawrence [Lawrence & Associates]   More Excel spreadsheet power tips - they're great!! Thanks! - Angela Abruzzese [Capital Cargo International]   Very interesting - Enzo Spinaci [Focus Group S.R.L.] Italy   I'm subscribing! Just fabulous. Your instructions and visuals make everything so understandable. Thanks so much! - Penny Maggio [Defense Supply Center Richmond]   Thanks - this is great. - Mary Pidgeon [BAS Analytics]   Great looking site. Fantastic examples. Goes to the top of my recommended sites for VBA. - Lee Hibbert   Many thanks for making available the code that prevents this (stopping the epileptic fit inducing screen update). Tried it straight away and with possible updating of 25 columns of data for 108+ staff for a year it saved loads of time. Super site, grateful appreciation! - Malcolm Wilbraham [PPA]   Thank you, thank you, thank you. I found this website that listed you as the person behind this clever end of month calculation. That @&%! end of month problem has been eluding me for 12 years (that's how long I have been using Excel). Thanks again - Robin Burns [Universal Studios]   Rodney: Thanks for the advice and taking the time to answer. I really appreciate it. - Will Perry, CPA [Bridgestone/Firestone, Inc.]   Thanks for your help, I really appreciate it. - Chris Acimovic   Have you stopped presses? This is the last issue my self and others have received, You got me hooked and the cut me off I'm going into withdrawal here. If possible could you please send me the issues I have missed and get me back on the mailing list. Thank you - Tim Ferguson [K2 Sports Corporation]   This site is excellent! Kudos to Mr. Powell!!! - Ed Destura [Eman]   Rodney, Thank you very much for this wonderful site ... - Muhammad Dawood   I am thankful for the data that you were able to provide me. It is of great help. Thank you - Joya Richardson [Liberty University - Student]   Thanks for the weighted average explanation and examples ... it was TONS of help! - Paul Plodzien [General Motors Corporation]   I like what I've seen on your site and look forward to spending many fun-filled moments exploring what Excel truly has to offer. As a user with limited Excel skills, I look upon your site as a chance for me to catch up and pass my fellow workers' skill- and trick-wise. Thanks and I shall give you feedback and ideas if you would like. Thanks, - Simon Lipert [Eraring Energy]   Great site. I was actually looking for a solution to find the last row. Thanks for all the tips. - Sam Varadarajan [Covansys]   I can use this to help with my books. Thank you. - Danny Wilson [Dan's Apple Farm]   Thanks for the excellent tips that this site offers for Excel Users. - Reg Vaz [Business Solutions]   Thanks for creating a site that allows someone who knows their way around a spreadsheet to learn something new. I am 16, and there's not much that people can stump me on. I have recently finished computing a stock market watch heavily using the IF, CHOOSE, and COUNTIF commands, and it would have made my formula checkng a lot faster had I have known about the ctrl + ` command. Thanks again - Craig Arthur   Thanks I enjoy your input. - Walter Goeken [R Goeken Farms]   Thank you in advance - Ian Grant Pitman [Project Economics International]   This site is much more helpful than Microsoft's own Excel help utility. Thanks! - Paul Mayes   At your site reference http://209.127.129.225/vba.shtml I read "SQL of Mere Mortals (Part 1 of 5)". Are the other parts available for reading? I am very impressed with the great articles available on your site. Thanks, - Susan Knowles [Andronico's Markets, Inc.]   Last night I went to bet thinking about my NEW problem (how to make the #cells in the range be variable). This morning I searched around, found your site, found Dynamic Named Ranges, and solved my problem (scheduling tennis matches for Friday nights). I am sure your site will be a tremendous asset to my night job. Thanks, - Phil Martineau [FNFB Tennis] Beverly, MA   This site is really helpful. - Joju Joseph [Mecklai]   Thanks a lot for the help - looking to learn much more about VBA for Excel - Alan Stigall [Creative Designs]   Hello, Just a quick e-mail to say thank you for the tips - they are easy to follow, and have saved me a lot of time since I started reading them. The explanation of the standard deviation was very clear and helpful. Regards, - Grant Humphrey [Ernst & Young]   Great site, learning a lot. Thanks - Paul Anceau [The HouseCoat Company]   Hi! ... I like this site. Cheers. Thanks. - Kamlesh (KAM) Trivedi [Omnicom Services]   This is good stuff for us novice Excel users who desire to become upper echelon users ... - Patrick Bowland [Engage Energy US LP]   Fantastic site !!! - Armando Valdes [CT Corporation]   Dear Sir, I am impressed with your web site and Excel tips. - Jagdish Shah   Nice web page. - Rafal Kacprzak [BRE Leasing]   Teriffic! I receive and use your tips at work - they are extremely helpful - and would like to receive them at home also. - Bob Rodgers [Phelps Dodge Corporation] Morenci, AZ   Rodney, You have an interesting web site - I perused it for longer than I should this morning. Just to say "nice job". - Terry Fritts [Smart Business] Edmond, OK   Thanks for spreading the knowledge! - Clinton Lee [Ugly Duckling]   This site rocks. I'm a starter and I found all the information cool. Thanks again guys for such a wonderful site to learn VBA for Excel. - Gerhard Groenewald [DeepBlue]   nice page - Martin King [Wirral Metropolitan College]   Rodney, Thank you very much for your help, this is exactly what I was hoping ot get. I really appreciate it. Thanks, - Ron Alcatraz [CLA Networking, Inc.] Grand Prairie, TX   Rodney Stumbled upon your web site today and spent 2 hours there looking over your tips etc. As a small business owner myself performing similar tasks as your company, I was very impressed with the content of your site. I am looking forward to receiving the Excel Solutions Letter. Thanks. - Bud Fulton, Business Manager [SAC Computer Solutions, Inc. ]   I've enjoyed looking at your site and learned a couple of useful thing. - Roo Davison [Terradigm, Inc]   Love your website -- excellent real world examples ... thanks, - Mike Cooper   Thank you - David Lanman   Great information on your site. - Ron Petitt [Software & Services]   THANK YOU!!! IT WORKED!!! ----- Thank you for responding and so quickly. ... Thank you! - Donna Smith   Dear Mr Rodney Powell: Thank you very much for your kindness and efforts to teach others such wonderful issues. God Bless You !! Such a pity that persons like you are one per billion. All the best. Best Regards, - Joăo Resende [Portugal Telecom, SA] Portugal   I've no words to express my recognition. Y're the best. Thank you VERY,VERY much. All the best. - Joăo Resende [Portugal Telecom, SA] Portugal   Rodney, Going through my desk drawer(recepticle for everything needy or not) I found a copy of email dated 11/27/97 to my old compuserve address (102553,742) advertising the letter with a note that I subscribed 12/2/97. My Company changed ISP's shortly there after and I don't think I ever got one issue. Wow- How much I must have missed since then!!! Glad you are still around I have become very interested in VBA this past year. - Maryellen Wells [Plant Process Equipment, Inc.]   Thanks.. - Eduardo Carrasco [APR]   Rodney, Thank you very much for such a prompt response and for the tip. I read it carefully and I am going to implement the solution. I am only slightly familiar with VBA but this is an excellent starting point ... ... Thanks again. ----- I am an eager reader of your Excel tips and I find them most useful. It is amazing in Excel how many ways you can have to reach your goal! Best Regards, - Janusz Poltorak [Owns Illinois IC.] Toledo, Ohio   I like your website. Good information for an Excel hack like myself. - Cliff Merritt [AMEC E&C]   Thanks so much. ... Next time you are near Newport Beach, breakfast, lunch or drink after work is on me. Thanks again. - Tom Sippl [Pacific Life Insurance Company]   I would like to start receiving your tips, someone forwarded me this address and you have some really cool stuff. Please advise how to start receiving this information. Thanks - Kay DeRoche [Stewart & Stevenson]   Hello Rodney: Your site is looking good -- very good! I like presentation of your examples and services. Nice picture! Good client references. ... My only complaint is that your $89 per hour fee is too low. You are worth more! - John Lacher, CPA and Microsoft MVP - Excel [Excel Help Page] Worthington OH   Dear Rodney, Thank you for your prompt answer. I will be investigating the textbox solution while I wait for the newsletter with the VBA alternatives for writing reports. Best Regards, - Mauricio Fulco [Societe Europeene des Satellites]   You seem to have some useful solutions, so I'd like to see more. - Eugene Larkin [U.S. Air Force]   Mr. Powell, A well written (and accurate) discussion of Std Deviation -- a subject normally difficult to explain to "mere mortals". Your Excel tips are always informative and a pleasure to read. I particularly enjoyed the Charting Dynamic Data tip. Thank you! ... goes on to offer an excellent Excel tip - Ken Futamura [AT&T Labs]   Thanks! - Amy Hawbaker [Survey Sampling, Inc. (SSI)]   Thanks - This is very helpful! - Lou Cioletti [U.S. National Aeronautics and Space Administration (NASA)]   Rodney, great job on the website and enjoying the tips...keep them coming. - George Willis [Fayez Sarofim & Company] Houston, TX   Thank you for a wonderful newsletter. - Wayne Noble [M-Web]   Thanks Rodney, This looks like some excellent information. I'm going to spread it around a bit. - Dede Burum [Booz Allen & Hamilton]   Please keep up your very good work. - Edgardo Noriega [Edgar Inc]   Thank you for the newsletter the tips are great! - Gabe Cote [Aqua Measure]   Many Many thanks for your newsletter. I learn the most from it. ... - Don Guillett [SalesAid Software] Granite Shoals, TX   Dear MR RODNEY POWELL, Thank you very much for such great newsletter, do you have any other newsletter which i can subcribe to, as i am great fan of excel, so much so that i only dream about excel, it is my passion. ... Thank you once again for such great newsletter. - Govardhan Bhatia [Panasonic] United Arab Emirates   Hello Rodney, ... your newsletters are really very helpful - thank you ! - Stephen Ashley   Rodney, Thank you, kindly. I will find many uses for this! - John Brizek   Your dynamic range name is very helpful - thanks. ----- Thank you for your help, you can't imagine the time and number of spreadsheets you just saved me. In my world, your "invention" here places you ahead of Edison's lightbulb. Regards, - Steven Schweitzer [Delaware Management Holdings, Inc.]   Thanks for helping me. This page is very interesting. - Franz Cardenas [FraMa Sowtwares Ltd]   Hi there Rodney, I found your web page after searching for some help and it is really well put together. I thought that I was bit of a whizz at Excel but not, you guys really know some clever stuff! - Philip Smith [ATC Lasham] Hampshire, UK   Very useful tips and tricks! - Nagnus Olofsson   I'm delighted! - Jal Nouda   Hi Rodney, Yea! it works. It looks like algebra formula with cobal programming. My brain just panics and I can't think it thorough. I thank you, the Financial Director thanks you. Have a great day. - Brenda Fradin [Arizona Society of CPAs]   Thank you so much. What an easy answer. Actually the formula you sent was the one i was using in the beginning. Once I changed the answer cell, everything worked out fine!!! thanks again! BTW: I used to live near Spring, Texas, in Humble (Atascosita neighborhood). Loved it there & enjoyed visiting all the quaint shops in Spring! - Fran Danner [TV Guide, Inc.] Oklahoma   Thank you for this mavelous resource. - Susan Melifonwu [U.S. Patent and Trademark Office]   This is a fabulous resource. I have just found it this moring and I am amazed to find so much useful information and examples. Thanks ... - Bob Mungovan [Computer Sciences Corporation (CSC)]   Really interesting procedures - and they work! - Joan McCudden [Marsh Management Services Ltd] Dublin, Ireland   My boss at work showed me his Letter file. He said I might want to subscribe since I'm always taking home work with me. Thanks! for a great and helpful letter! - Debi Caldeira [K2 Corporation]   I am excited about it. - Tersam Heer [Fairway]   It's very generous of you to provide this information. It seems you have a successful business, and I hope it will continue for you. - Jimmy Day [Digital Photography]   Rodney Your monthly newsletter is extremely beneficial and insightful. I thoroughly enjoy reading it. - Brad Firsich [Franks Industries, Inc.]   Rodney, Loved the newsletter (I just signed up). ... goes on to offer an excellent Excel tip - Ashley Williams [Continental Airlines] Houston, Texas   Hi Rodney, ... Brilliant website by the way - it's my Excel bible-on-the-web! All the best, - Karen Alston [CPM International] United Kingdom   Hi there Great homepage! ... goes on to offer an excellent Excel tip Kind regards - Jan Vogt Hansen [Maersk Contractors] Denmark   Hello, I've had a look at the offset method approach for naming dynamic ranges. Very interesting. ... Thanks and well done for the newsletter. - Rosemarie O'Neill [Ramesys] Nottingham   Thanks, I do like your work and effort. - Carlos Gonzales [GSA Computer Enterprises, Inc.]   I found your website very helpful. I am particularly interested in the VBA language. - Deborah Esegbona [Ese's House Ltd]   I found this site and I think it is great !!! - Leigh Toth [HMS Host]   I appreciate this. It is quick, to the point, and provides avenue to further information. GREAT JOB. - Jim Brunick [Lockheed Martin Aeronautics Company]   Rodney, I found this very helpful. Thanks - Rich Guard [Teradyne, Inc.]   First of all - thank you for a useful information source - I have used several of your tips to make my work easier. Thanks - Matt Lausten [Tucker Alan Inc.]   Keep up the good work! - Daniel Ward [Dominion Virginia Power]   ... Great newsletter, keep it up!! Best Regards - Tim Key [Air Logistics, Inc.]   Cool! Thanks! - Cindy Prestidge [Hewlett-Packard Company]   Dear Sir, Thank you very much for your tips. I am a Mathematical Engineer and also an instructor teaching Microsoft Office Programs. Therefore, tips that you sent are useful for me. Yours Sincerely, - Emine Sever [Erdemir Iron and Steel Works Cooperation]   Rodney, ... I want to thank you very much and I look forward to receiving additional mailings. Best regards, - Maurice Hevey [Convergent Cosmetics, Inc.]   Thanks - Randy A. Shively   Thanks! - Roy Long [U.S. Department of Energy (DOE)]   Thanks for the tip ... - Oliver Karp [Interviewing Service of America (ISA)]   Rodney, I've been using your Web site WWW.BEYONDTECHNOLOGY.COM and it's really been helping me out with some of the things that I knew Excel could do, but wasn't sure where to begin. Your article on Printing Full Path in Header/Footer caught my attention, particularly because I save files in many different subdir. and sometimes forget where they are. Printing the path in the footer is the perfect solution ... - Pam Trbojevic [PNC Bank Corp.]   Rodney, Thank you, it worked. - Paul Scovill [Catholic Youth Council]   Rodney Thanks for the EXCEL Solutions Letter ... - Joe Knofczynski [U.S. Army]   Hi Rodney, I don't know how I got on the list for the Excel Newsletter but I am glad I did. It is nicely done and practical. - Robert W. Meyer, D.Sc. [Numerical Algorithms Group]   Thank you very much for the letter ... - Luis Alberto Román [Mirasol S.A.]   ... Thanks a lot. Sincerly - Jefferson Hoyos [El País S.A.]   Thank you for the information. This will be very helpful to me. I hope to hear from you again. If I can return the favor, please do not hesitate to call on me. - Larry Gardner [Cummins]   Thank U - Vishwanathan Ns [Weizmann Ltd.] Fort, Mumbai   Thanks This may be very helpful. Thanks a lot. - Larry Belk [Union Tank Car Company]   Rodney, Thanks for including me on the mailing list for the Excel Solutions Newsletter. ... - Steve Abbott [Duke Energy]   This is cool - thanks. - Vu Nguyen [MidAmerican Energy Company]   Thanks and very nicely navigated Web site. - Alan Villiers [Harry S. Truman Memorial Veterans Hospital] Columbia, Missouri   Hi Rodney Powell, I liked your site very much. I like it that it has excellent contents and Excel Macros that have many uses, work well and are written in short concise codes. Keep the good work. - M. Ali Khan [Oil Gas and Geothermal Resources]   Thanks and I really enjoy the newsletter. - Gary Smith [City of Sierra Vista, Arizona]   On my first visit to your site you answered a nagging Excel question: how to get rid of phantom links. Also, your review of dynamic named ranges was excellent. This is a very powerful tool that too few people know about. Great advice and really nice web site. - Bruce Blake [Repsol YPF]   I've used several of your tips and procedures and have saved enormous amounts of time. Thanks. - Dennis Butler [ATR Distributing]   Keep up the great work and thank you. - Robert Westin [Major Dynamics]   I have been browsing your Web site and thank you for making this such an interesting site. I am convinced that it will help me greatly in my learning curve for VBA. ... Thanks again! - Larry Egab   Thanks, great site. - Dave Hawley [OzGrid Business Applications] Australia   Thanks for the VBA samples! They saved me a lot of time. - Ian Goodsell [Compuware]   Found you on a random search of the Web. Excellent tutorial - thank you. - Ewen Sim [NW Regional Action Team]   Thank you for the service. - Paul Shaw [PCD Training]   Your newsletter is awesome!! - Scott Senffner [Central Enterprises]   Hi - I'm just a new visitor, but from what I've seen it looks like a great site. ... Thanks for this - it is really good of you to reply and so quickly. I am really grateful for your help. - Peter Talent [Klaussner Furniture UK Ltd.]   I quite enjoyed your Geek corner and I am not ashamed of it. In fact, I think you can do very nice things with this huge tool box. - Hans-Göran Branzell [Westinghouse]   Hi Rodney, First off, great site - I learnt precisely 4.2 things I didn't know, and for this I thank you. ... PS I look forward to the newsletter! Cheers, - Damian Glenny [Bank of New Zealand]   It's a beautiful datasheet to work on. Nice efforts have been put up to make it more powerful. - Mustyafa Jawadwalla [Jawadwalla Shop]   Thank you so very much. You are so great to take the time to solve my problem - and that you did. - Bob Dawson [Perma Structo, Inc.]   MVP Excel SITE - Good site ... hope your newsletter is of the same quality ! - Michel Scheffer [Scheffer Consultancy]   Nice site, good info. I will bookmark you. - Adam Phoenix [Sandhill Consulting, Inc.]   Your page design is excellent. I am very skilled at manipulating data with VBA for purposes of analysis. ... I would now like to take the next step silimar to you! I greatly appreciate any insight, tips, or encouragement on how to proceed. Hope to hear fro you soon! Sincerely, - John White [BOX Packaging, Inc.]   Very helpful! - Anthony Moore [Gold Today]   Great offer! - Vernon Williams   Rodney, First let me say, as a seasoned Excel user and a beginning VBA programmer, I enjoy your website and continue to find useful pieces of information about Excel and VBA. It's always nice to find websites that stick to the topic they are supposed to be about. - Jeremy Boughton   Thanks! - Michael Clark [Evanite Fiber Corporation]   Rodney, I am truly indebted to you. It works great. I appreciate your knowledge and time in this area. Many Thanks! - Jeff Carapella [VSA Group, Inc.]   Hi Rodney, First I want to thank you for sending me the Excel Newsletters. I visited some many sites looking for real life examples to help me overcome programming issues. Receiving the newsletter reminded me of what I learned from my first visit to your site. "YTD Formula". Each time I visited your site, I attempt to incorporate something else. Again thank you. You are one who's knowledge is helping many. Sincerely, - Benjamin Cassaberry [CPASoftware]   Rodney, I used your tip regarding dynamic named ranges a couple of months ago (I think you may have answered a question that I posted on an Excel list group) and it really saved my day. It really helps to have a tool available that can lead you to a solution. Thanks again! - Pam Trbojevic [PNC Bank Corp]   A perfect site for Excel-users - easy to navigate and with very helpful topics. Thanks for the help provided with all kinds of "Excel troubles." Best regards from the Netherlands, - John Koster [Jena] The Netherlands   The tip on dynamic named ranges is excellent and just what I need for a VBA project - thanks! - Jonathan Gale [White Horse Computer Training]   Your website is great. Lots of good tips and solutions. - Jack Russell, Jr. [Aetna Financial Services]   Love your site. I'm definitely in your 'geek' group. I've been developing spreadsheet solutions at work for years. Array formulas are about the only thing that routinely leave me fealing lost. Any time you feel like throwing in more array solutions, you'll have at least one reader bowing to the all-knowing guru! Many thanks for the solutions you provide. - Thomas Robbins   Thanks for the newsletter. Please keep them coming. - Larry Taylor [VCC]   Thanks for this example. I have learned a lot. - Nico Leroux [Toyota]   Wonderful newsletter! - Zhigeng Fan [AT&T]   Great picture Rodney!!!! I had to look at it twice to make sure it was you. The web page is pretty cool too. ... - Jackie Powell [Hewett Associates]   Keep me posted - we will work together again in the future. - Steve Mattingly [Spectratech]   I am very pleased to receive your tips. ... - Wim Bekema [Centrum for Adult Education Diemen]   Thanks !! I will have to try some of this. I think this is great !! - Tanya Cornell [Continental Airlines] Houston, Texas   Thank you for your literature. I have recently moved from the Lotus 123 environment and into Excel 97. I don't mind admitting that I found the transition both easy and difficult. Your material is now safely in my "Favourites" section and will be extremely useful in these early days. I look forward to your next release. Kind regards and all the best. - Ron Anderson [Comet Group PLC] England   This is a great tool. Thanks! - Rick Mandahl [Impression Design]   Hi Rodney, Been through your excellent site and picked up quite a few tips. ... - Marzban Hathiram [Citigate Dewe Rogerson Communications Pvt Ltd] Mumbai, India   Wonderful! - Henry Yennie [The WES Group] Baton Rouge, Louisiana   Excellent site. Keep me updated. - Ernesto Barberena [Bladex] Panama   Rodney-- First, thanks for putting up the site and sharing your knowledge - your tip got me out of a bind. And secondly thanks for mention about the Mac solution. - Mike Klein [Austin Printing]   Love the Excel tips! - Ron Hopkins [First National Bank]   ... I like the code examples, nice and snappy ... Regards from Down Under, - Austen Marriott [e-Focus] Sydney, Australia   Your site is very helpful. ... Thanks in advance for your help. - Jeff Blasbalg [Resolve Technology, Inc.]   It's very good. - Christobal Munguia [MUSAN]   This is an excellent resource for Excel users, more helpful than the company that designed Excel. - Courtenay Anderson [Devon City Council]   Thanks! - Roy Irwin [L&E Packaging]   I like the way you describe Excel formulas. - Mohammad Keshtiari [Excel Experts Group]   I copied your code about using UDTs in functions. I wish I had that months ago ... - Deborah Strickland [Cisco Systems]   Very helpful site. - Abraham Torres [Monsanto]   You da Man! Great Site, issues clearly defined. Great Job! - J. Donleavy [Hewlett Packard]   Thank You Very Much :)) - Joao Resende [Portugal Telecom, SA] Portugal   ... This is really great. Please keep me updated, as I'm an Excel buff. - Sathya Prasad [HCCBPL]   Dear Rodney ... Thanks for your wonderful page on Excel especially with regard to the very useful advice and tips. - Udo Boesenberg South Africa   Your visual basic site is very useful - especially for someone like myself. - Darren Eagleton [Compaq Computer Corporation]   I was going through the vb basics and I liked it. The examples there are very good. - Kumar Shiv   BEST WISHES !! - Mohsen Zandieh [KPSM]   Love this page ! - Muhammed Vanker [University of Durban-Westville]   Thanks for taking the time to put worthwhile examples of VB code on your website. That demonstrates to me you have class. - Jim Friederick [Creative Value Solutions]   Great! Thanks for your help. - Michael Hopewell, Tech Supt Asst [Origin IT] Cheshire, England   Hi Rodney, Wanted to let you know that you've got some great tips on your site (though I guess you probably already know). What I particularly liked was the focus you gave to dealing with problems using the tools that everyone has at their disposal, and not just writing code for everything. ... - Michael Gurner, IT Training Mgr [Merchants Ltd] Milton Keynes, England   wow Thanks for the tip regarding "formula viewing" (ctrl + `). No one had it but you! Best, - John Millen   Thanks for demystifying VBA. - Jerry Parwada [Edith Cowan University] Perth, Australia   Thanks a lot - Akram Najjar [InfoConsult]   ... I really like your Web site - clear & simple ... - Pierre Leignadier [Visual Prices, LLC]   Rodney: Thanks, you had some pretty useful "geek" tips on your webpage (BTW, I also liked its design). ... Thanks, - Alex Gostevskikh   Rodney, this is an A+ site for beginning VBA. I've done PC training for 11 years, and get very frustrated when people end up going heads with their (poor) explanations, either verbal or written. It is a pleasure to go through your articles -- first thing I've found on the Web that was written just for Excel VBA that is anywhere close to usable. It was exactly what I was looking for ... only better! Thanks again. - Alison McGee [Fayette Companies]   Rodney, Thanks for some useful tips. I have been helped particularly by the 'find real used range' procedure. ... Also very useful is the 'dynamic range names' it has saved me some VBA code when users add items to the lists. - George Cooper [George Cooper Consultancy] Australia   Great site - your "bogus links" module saved me a lot of time and frustration! Thanks! - Bill Sullivan [Business & Legal Reports, Inc.]   Thank You - Mary Ellen Reinhardt [Comprint]   I enjoyed going through this site ... very informative. - Lynette Machado [Maersk] India   Subject: Your Excellent Web Site Rodney, I found your web site whilst searching for info on Excel VBA using MSN search yesterday and am delighted that I did - the site is excellent and full of useful, free information (somewhat uncharacteristic of today's web!). I found the info on finding the real last cell particularly helpful as I am always writing procedures to handle data ranges and had similar concerns about the "CurrentRegion" / "XLDOWN" / "ROWS.Count" methods, so it was re-assuring to know I was not alone. ... I think this is a great site. Are there any plans to expand on it's content? - Adrian White [CPM UK LTD]   Rodney Powell, Thank you very much for your advice. - Warren Junkeer [Concert Communications]   I like to see your expert comments - Neil Suriyaarachchi [Sri Lanka Telecom Limited]   Great thankyou! - Dave Land   Thanks very much. - Kenneth Athon   Thank you for helping me! - Marion Stoll Australia   Hi Rodney I found your examples very helpful. ... Thank you very much for your help. I was able to modify the code you provided below and it worked! ... - Larry Beach [Intel]   Rodney, Your formula works great. I was including the commas after the true statement. ... Thanks for the help and I really like your website. - James M. Orr [Tri Valley Growers] San Ramon / Modesto, California   I love your page thx ... :) - Dave Rattigan [Parlex]   Great site !!! - Mark Johnstone [IHC Gusto Engineering B.V.]   GREEN PARROT ... I like it very much. - Bulent Hatipoglu [Istanbul Technical University]   Rodney. Thanks. My printed spreadsheet now has gridlines! Chow - Ted Shaw   Thank You Very Much - Abdul Bassit Al-Mahmood [Arabian Management Think Tank]   Hi Rodney, Loved the dynamic range info. ... Cheers - Chris Black   Thanks a lot - Mihai Enuica [Central Europe Trust - Romania]   Chip Pearson included your site in his 'tips for new posters' on one of the excel newsgroups. Having read Chip's replies to questions and visited his site for three or four years, I've learned to trust what he has to say! I was not disappointed in your site - it is attractive and very well laid out, and you are obviously very knowlegeable about excel and VBA. As Arnie said, "I'll be back!" Cheers, - Dean Cardno   THANK YOU! - Christine A. McCreary [Tyco Electronics]   Just wanted to say that I love the Beyond Technology site. The VBA info there is excellent, and has helped me figure out some sticky problems -- after hours of fruitless searching on the MS site. :( Thanks for providing the info. - T L Trevaskis [Network Equipment Technologies]   Hi Rodney, I visited your Excel VBA page. It's very helpful for my Excel programming project. ... Thanks very much. Regards, - Dennis Khoo [Shell Services International]   Very useful articles on this site. - Christian Steenberg   Found out about you folks from a Yahoo! query - then read through and like the info and format of your site. - Robert DiGiorgio   Thank you Rodney for responding so rapidly. ... Have a great day and thank you so very much for your assistance. - Linda Shipp   VERY helpful site! - Jim Youngman [Solunet]   Thank you very much for your assistance. - Jerry   Great site. - Deborah Lewis   Thank you. - Filip Heyns [Life]   Thanks ! - Nicholas Kow [SPT]   Rodney, I appreciate all the great information you make public on your website. I can't tell you how much use I've made of dynamic named ranges! ----- I appreciate your informative Web site. Thanks for sharing your knowledge base. - Curt Smith [Black & Veatch] Orlando, Florida   It's quite nice to know that such a great development company exists in Houston. - Taha Kass-Hout M.D., M.Sc [UT Health Science Center] Houston, Texas   I think this site may be very useful! - Celia Pennington [Bell Atlantic]   Excellent !! - Alcebiades Junior [Promtus Informatica] Brazil   You do good work. - Richard A. Floyd [R. A. Floyd - Computer Consulting] Long Beach, California   Found it by just typing ExcelDeveloper.com. Didn't think there would be a site devoted to it but was pleasantly surprised. Can't wait to get the newsletter. ... - Kevin McCane [ezBid.com]   This Web site is very good and useful to me and many students who are studying Information Technology. - Tanny Nguyen [Tanny Family Pty - Ltd] Australia   I like your project profiles section - nice to see VBA being applied in these large companies. - Paul Dysko [Dysko Woodworking] Ontario, Canada   Thank you ... - Mark Schukas [MJS & Assoc.]   Nice website! Looks good, good content, not too much fluff. Good layout too. Impressive. - Steve Ash [City of Waco] Waco, Texas   Very nice Web site. - Tracy Cortez [RAC Construction]   Love you guys - Carlos Urias [Eller Media Company]   So far what I have found this is an outstanding site to learn more and more about Excel. Thanks to all who provide us with such information. - Joe   Thanks for your candor and willingness to help. God bless. - Joe   Excel-lent Web site. - Vincent Amari   In the past I have found this site to be an excellent source of information. - Steve Skornia Houston, Texas   Searched for "just-in-time" inventory, as we are transitioning to it; and found an Excel model ... this is more than I hoped for! - Helen Kipplen [Lucas Metropolitan Housing Authority] Toledo, Ohio   Very impressive website !!!! Yes, VBA is not easy to understand fully, and it takes time to learn it. - Stanley Rozewski [Abbot & Stuart] Chicago, Illinois   Again ... Rodney Thank you very much for your help. - Eduardo Valles Uruguay   Dear Rodney, I would like to receive "Excel Solutions Letter" by e-mail. I'm beginning on Excel programming and enjoy to receive your tips for best sites on internet. Best Regards, - Andre M. Favaro [Renault] Curitiba, Paraná, Brazil   Great tips. Look forward to more ... - Andy Kansky [Leighton Contractors]   It's great communication on Excel sharing knowledge. Thank you for this. - Tjetjep Rustandi [Conoco Inc.]   I'd have been here sooner if I knew it existed! - Nhlanhla Mdlawuzo [Komradz Inc.]   It's great!!! - Cesar Serra [Universidad del Pacifico]   I very much appreciate your tip on Dynamic Named Ranges. - Jeff Pickard [Lexite Development]   I think it's great that you have a help letter. I have difficulty remembering the formulas. Thanks, - Sharon Stegner [Caprice Motel]   Thank you very much. All the Best, - Joao Resende [Portugal Telecom, SA]   Thanks for providing an interesting AND useful site. Keep up the good work!! - Billy Thomas [Cherry Software Applications]   Just one more of many kudos. We continue to learn. So many visitors. I hope you have as many thank yous. - Don Guillett [SalesAid Software] Granite Shoals, Texas   Hey Rodney, I just wanted to let you know that I finally got around to using your tip about array formulas in your June E-Mail for my orderform I told you about. It works GREAT! I now have 3 times the orderform with more features for 1/5 the size. Thanks again. I hope all is going well. Take Care, - Mark LeBlanc [Time Warner Communications]   GREAT !!!!!!!! - Wendle Hasham [Hasham N.V.]   Great JOB -- this is an excellent site for Excel users. - B.L. Lau   I liked it!!. - Freddy Meza [Tecsup]   Thanks a lot to those people responsible for this site. Much Regards. - Ramelo Gusilatar [Analog]   Wonderful article from Mr. Powell. Just perfect. I don't care what they say about MS, Mr. Powell's article hits the spot. - Warren Montgomery [Banker & Tradesman]   I am extremely appreciative of the availability of all the Internet MS 2000 resources. - Nancy Connery [USFilyer/Niagara Screen]   Good work. We, out here in the line of fire, need something like this. - George Mustafa [GRM Data Solutions]   Thanks, Rodney, for the FAST response!!! - Teri   Hi, I'm Frank from Hamburg, Germany and I am impressed about your real professional site. I'm working as an MCSD Backoffice Consultant for German Customers. I would like to take a look at your Excel-newsletter! - Frank Hennig [Softmatic AG]   I'm an intermediate user and have found some very useful tips, which i've passed on to others in my office. Thanx for keeping this going. - Mike Atchley [Harry S Truman Memorial VA Hospital]   The VBA tool for finding external links works like a charm. Thanks - that little problem has been haunting me for years! - Michael Adams [Genentech]   Hello Rodney, I just started receiving "Solutions Letter" into my e-mail from Beyond Technology. Going to the your web page, I have found some GREAT!!! information. THANKS!!! - Dipak Pramanik [Ericsson]   Rodney, I can't thank you enough for all the work you've put in on your site. I teach Excel VBA, and not only is the information on your site useful to me in that regard, but my students really like to have a resource they can come back to after class. Thanks again! Sincerely, - Julie Kinnett   ... If your products and services are as good as that dynamic SUMIF array formula, you guys are REALLY good. ... This was my first time reading your online newsletter. I think it's great. Keep up the good work ... - Chris Bowman [Lafourche Parish School Board]   Rodney, Thanks for including me in your subscription list. This is excellent (as is David's EEE). This item {SUM with Multiple Criteria} alone addresses a neat idea that popped into my head yesterday. - Hiran de Silva [Space Out Ltd.]   Dear Mr. Rodney POWELL, Please believe that this letter that I receive from you time to time, is probably one of the best things that happens to me on the net! I find your letters extremely useful! Thus, please allow me to use this opportunity to thank you and your company from the bottom of my heart. - H. Mete Izmen, MCSE [Gucyapi AS.] Turkey   I appreciate your prompt and helpful response to my question. I believe I can use what you have created to get my task completed this summer. It is refreshing to know that people like you volunteer their talents and expertise for the benefit of others. Your response has probably saved me endless hours of frustration and agony. I applaud your efforts towards assisting others learn and better use technology and it's direct use in their lives. Thanks again!!! I appreciate your help! - Daniel F. Sterenchuk [Collins Rockwell]   Your Web page is impressive. What is your current rate for Excel consulting? - Joseph Koothrappally   The "How To" section is very informative. I've been pulling my hair out trying to come up with a way of finding the real last cell. Thanks a million! - Steven Sanders [Celestica]   Thanks that was all I needed. (30 hours and could not find this anywhere on the web). - Russell Timmerman   Thank you for this Web site. This is my first time and it is terrific. It has the answers to many of the questions and sticking points that I've had so far. - Vicent DiMarco [DiMarco Consulting]   It sounds as if you did a lot of in-the-trenches research from real users to pak this many features. - Alan Palmer [PsiProd Communication Systems] Atlanda, Georgia   Been searching for VBA resources specifically. Found this site from VB Magazine (I believe). This site has been pretty helpful. Keep the samples coming. That's right what I need for the app I'm working on. Thanks mich. - Matt Hellberg   Nice website. We would love to get to know the new features even better. - Bill [Barney Boller]   Hello Rodney, I fixed it, it works!!! thanks for your tips!!! ... Thanks for your inspiration - Jose Marin [ABB]   Thank you so much. Seems the problems I have the most trouble with are the simplest to fix. You've saved me major headaches. - JoAnn   One word : your website is Brilliant ! Congratulations and thanks for the help ! - Sébastien Noël [Cablofil, Inc.] St. Louis, Missouri   Thank You for the 'solutions'. - Niko Osolnik [OKEN]   Just thank you for your commitment! - Gianfranco Marino Bologna, Italy   Thanks for your VERY informative web site! - Jim Mace [Bell Helicopter Textron]   Hello Rodney, Thank you for your Excel Solutions Letter ... It is always interesting for me to read this letter. - Dick Lokhorst [Lokhorst Holding B.V.] Amsterdam, Holland   My students love your site, by the way. I have shown them some of your examples for User-Defined Functions. Thanks again for the great site. - Julie Kinnett [KinnettNet]   I am always looking for tips. Keep up the good work. - Kenneth Moulton [JDPower]   Rodney, Thanks for the great tip on using CHOOSE for YTD formulas!! ... ----- What can I say? With this month's power users tip, you prove yourself as a certifiable genius!!! Thanks so much for finding a way to return text on a multiple criteria lookup. - Joel Horn [Continental Airlines] Houston, Texas   Rodney Thank you for the EXCEL SOLUTIONS LETTER. I enjoy it greatly. ... (see Craig Rice's contribution in YTD formula) ... Keep up the good work! - Craig Rice [Torch Operating Company]   Have found this to be very informative. Thanks. - Steve Skornia [MOSS Design & Development]   Hello Rodney, I am an Internet programmer. I was viewing one of the Web pages of yours which had valuable information for Visual Basic for Applications. I was really impressed with the quality and clarity of the documentation. ... - Madhu Lal   What a site. I have to list your site on equal with John W's. I had thought it had no equal but I am convinced. - John Augustein [T & W Forge Inc.]   Dear Rodney, Thank you very much for your help -- the solution you gave me has worked properly. Cheers. - Tony Odubanjo [Nurek Ltd t/a T & K International] England   I don't know who I talked to today on the phone, but I am thankful for the help. My question was ... - Joel Chaban [All Things Connected]   Many thanks for your newsletter, it was the first time that I received it, and I was really pleased with the content and coverage. I have also dipped into your website, and have found that very useful, particularly in resolving the irritating problems that crop up from time to time. - Alan Hutchins [The BOC Group]   I like your Web site. Your examples are clear and to the point, without a lot of superfluous code to confuse the issue. Good job. - Kevin Romero [WEBSC]   Dear Rodney, Thanks for the help you gave me with my booking system project. ... Thank you again for your solution and for taking time out to even create me an Excel file to demonstrate what you meant. It turned out to be most excellent and gained me an A* grade. Thankyou very much for your help and I also thank you for sending me your Excel Solutions Letter. ... Keep up the good work and I hope you continue to solve many peoples problems like mine into 1999. Happy New Year - From Your Friend - Gary Woods England   Thank you for an excellent site. I don't think it's possible to open a three hundred page book and get a feel for the basics as quickly as your site provides. - Josh Freivogel [USA Trading]   Thanks for the help Rodney! - Bill Mullin   I just read through your pages about VBA and I think they gave me a good preview of the concept. Thank you, it's much appreciated. I shall bear your site in mind (and as a bookmark, for safety:-). - Per Ekelund [Ericsson]   Thanks for sharing your solutions to Excel problems and suggestions to incorporate Visual Basic in applications. Even though I have many professional books on each application, I found a lot I could use. - N. Marie Ricketts   Thanks a lot! ... - Mete Izmen [Gucyapi As.]   Thanks! Your site looks great. It's a wonderful learning tool. - Timothy Barmann   Hi Rodney! Thanks very much for the skill and assistance you provide in your site devoted to EXCEL/VBA. In the list of the few true experts, certainly you are one of them. I wish you have a Happy New Year. ----- Merry Christmas Rodney!!! And thanks for your wonderful work in improving Excel/VBA. From Hot Brazil - Jacob Rotman [Rotman Consultoria] Rio de Janeiro, Brasil   This is a very interesting page. I wish it had some downloadable Excel samples. But, nevertheless, I like this site! - Jan van Vossen [MMP]   Your tips are great, especially the Power User tips ... Thanks again, and keep 'em coming. - Lloyd McBride [McBride Software]   Thank you for providing such a useful Web site! - Doug Oldmeadow [Cleanaway]   ... Thanks for a wealth of Excel information! - J. Kinnett   Thanks for providing this information. I like your "OFFSET" tip for dynamic ranges. - Chris Bowman [Lafourche Parish School Board]   Hello Rodney, A mail from the Netherlands! Thank you for your Excel Solutions Letter. It is interesting to read your tips and solutions. - Dick Lokhorst   Rodney, Thank you for the rapid response - I did not think that Texans got up this early in the morning! - Michael A. Picot   I've come to appreciate your straight forward tips and information. I tuck them away for future use when it's not something I'm currently in need of, but useful to have the expanded knowledge of what's possible. - Dave Messersmith [Bechtel Corporation]   I'm very enjoyed about your Web site. It is very informative. Sincerely, - Gisela Rakow Saarbruecken, Germany   Your Web page is excellent. Yesterday I saw your Web page and I found the solution of my problem. Thanks. - Paola Arnao Loyaga [Organización Internacional del Trabajo]   Greetings. I just visited your Web site and it's a work of art. Good job!! - Bill Huang   Rodney Powell, Thank you for your useful Excel Tip at the newsgroup. It's quite helpful. - Stephen Lam   Thanks you very much for your help with my project. Your speedy replies and helpful answers have made my project into an excellent one. - Jonathan Brook   That response wins the Lightning Response of the Month Award. Thanks. - David Winsemius [MassMutual]   Thank You for the response. I have never received a response to such a question, and your response was almost as fast as my system processor. - Alan Temple [HOK]   Rodney; I have been writing macros in Lotus 1-2-3 for years,but now that my company has switched to Excel, I am working on learning VBA. Web pages such as yours have been/are extremely helpful. ... Your "dynamic named ranges" will be quite useful ... I am looking forward to receiving your newsletter. - Ken Hardwick Norman, Oklahoma   Rodney; Thank you very much. You hit it right on the money. Yes I can work it from here and I very much appreciate your help. - Kenneth Bullock [Ardak Corporation]   Rodney, Thanks for the Excel advice! Best Regards - Anders Blom [Pharmacia & Upjohn] Uppsala, Sweden   Thanks for your solutions letter, Rodney. I am a big fan of Excel and always looking for you clever boys to learn more stuff. I use most of my Excel for financial stuff as I am a derivitives trader at a bank. Always looking for a clever function and stuff. Thanks again. I will check out your Web site again soon. - Glenn Roberts [Nat West Markets]   Special thanks to Rodney Powell at Beyond Technology for his excellent explanation of Dynamic Ranges and using the offset method. It really got me thinking. - Mike Davis [TheOffice.Com, Inc.]   Thanks Rodney, You solved a big problem for me and you did it so fast. Much appreciated. - Dale Adams, CPCU [Staffing Resources, Inc.]   Dynamic named ranges. This is truly a gem! Interestingly enough, I have been trying for a while to come up with something to fill a particular need, and this is perfect. - Nils Jonsson [Fayez Sarofim & Company]   Wow Rodney Thanks a lot. Just when I thought there was no hope, you came through. ... What else can I say. People like yourself are what makes the Internet great. Thanks again -- and may only good things happen to you. One very happy Greeb :-) - Martin Cruise

home   professional consulting   developer tips   visitor kudos   e-mail   Your suggestions and comments are greatly appreciated. Please keep them coming. Mail to:   rodney@beyondtechnology.com All terms, product designs, and company names used in this site may be trademarks or registered trademarks of their respective owners, and are hereby acknowledged. © 1996 - 2010 Beyond Technology. All rights reserved.