Reliable Spreadsheet Solutions - Call Now 281-379-2000 Microsoft Excel - Visual Basic for Applications Consultant Reliable Spreadsheet Solutions - Call Now 281-379-2000 !
PROFESSIONAL SOFTWARE DEVELOPMENT
Reliable Excel VBA Solutions !
 
Microsoft Office : Excel - Visual Basic for Applications [ VBA ] Software 

Beyond Technology

Insight for Microsoft Excel POWER-Users
  Excel Solutions Letter ® FREE  excel solutions letter
Spreadsheet Power-User Tips
  Enable ease and consistency of data entry with a dropdown list of possible entries for a range  dropdown list in cell
  Designing an array formula that functions similar to a VLOOKUP function with multiple criteria and returns a text entry  mult-criteria text lookup
  How Excel workbooks become bloated and what can be done about it  spreadsheet bloat
  Spreadsheet Power-User Tips  more ...
Getting to Know Microsoft Visual Basic for Applications
  Decision Structure that conditionally executes the embedded code  if...then[...else]
  If you are new to VBA and trying to get a handle on programming, this is a MUST READ article for you!  what are variables ?
  Discover a special, more flexible variety of arrays  dynamic arrays
  Getting to Know Microsoft Visual Basic for Applications  more ...
Microsoft Excel Advanced VBA - Just for Geeks
  MUST SEE!  A named range that expands and contracts automatically based on the number of items in the source data table  dynamic named ranges
  MUST SEE! How to identify the last used row in an Excel worksheet  finding real last cell
  Creating charts that adapt as the size of the source data range varies  charting dynamic data
  Microsoft Excel Advanced VBA - Just for Geeks  more ...
Excel Spreadsheet Tools and Tutorials
  Mortgage & Auto Loan Payment Calculator » Amortization with Excel Spreadsheets  amortization guide
  Breakeven Analysis with Excel Spreadsheets Tutorial  breakeven analysis
  Permutations & Combinations with Excel Spreadsheets  combinatorics
  Standard Deviation in Excel Spreadsheets Tutorial  standard deviation
  Weighted Average in Excel Spreadsheets Tutorial  weighted average


Microsoft Excel VBA Custom Application Development
  Microsoft Excel VBA Custom Application Development  excel vba customization
  Microsoft Excel VBA Professional Development Experience  professional experience
  Microsoft Excel VBA Custom Application Development  project request form
Microsoft Excel VBA Solutions : Real-World Project Profiles
  How deep is your data?  engineering analysis
  Financial reporting can be a challenging endeavor.  financial reporting
  To anticipate customers needs is to be rewarded with their business.  sales forecasting
  Are time-hungry paperwork tasks building up on you?  automated billing
  An Engineer-in-a-Box  engineering design
  Partial List of Beyond Technology Clients - Past & Present  clients - past & present


Reliable Spreadsheet Solutions - Call Now 281-379-2000 !
  Visitors' Comments  gratuitous kudos
  Add to Favorites 
  Reliable Spreadsheet Solutions - Call Now 281-379-2000 !  e-mail contact

20831 Rosehill Church Rd
Tomball, Texas 77377



Visitors' Comments
Microsoft Certified Solution Provider

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.
Beyond Technology 281-379-2000
Microsoft Office : Excel VBA - Visual Basic for Applications Software


Microsoft Excel VBA - Visual Basic for Applications  Rodney,

...

Thanks for your help!
- Kevin Cunningham [Compass Bank]
Microsoft Excel VBA - Visual Basic for Applications  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,
Microsoft Excel VBA - Visual Basic for Applications  Last Excel Row - Thanks!

You rock.
- Bill
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  are awesome

this saved my life

=OFFSET(MySheet!$A$1,0,0,COUNTA(MySheet!$A:$A),1)

THANK YOU
- Steve Brooks
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

I was reading your site and it is a great help to so many people . Thank you.
- Travis Weaver
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,

Your article on shrinking spreadsheet bloat was fantastic and VERY helpful.
- VL Vawter
Microsoft Excel VBA - Visual Basic for Applications  Hey,

I just checked your site. It is good. You have described the things very well.

Regards,
- Ravi Sagar India
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Just a quick thanks - nice site.
- Cam Howie [Lake Erie Steel Works] Canada
Microsoft Excel VBA - Visual Basic for Applications  EXCELLENT

Thank you,
- Mark Stinson [Lockheed Martin]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

I stumbled across your geat Excel tips and techniques and found at least two formulas that will help me.
- Mike Connolly Phoenix, AZ
Microsoft Excel VBA - Visual Basic for Applications  Hi, I purchased your breakeven analysis guide with Excel sheets. It was a big help ...

Sincerely,
- Sherilyn McGah
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Great site. It has been very helpful.
- Andy Male
Microsoft Excel VBA - Visual Basic for Applications  You gave the answer when the MS Help gave nothing - THANKS!
- Marjorie Kolkin [Compass Systems & Programming] Exeter, NH
Microsoft Excel VBA - Visual Basic for Applications  Good morning! Your site is very professional and the content you provide gratis is useful even to advanced Excel users.
- Paul Gillespie
Microsoft Excel VBA - Visual Basic for Applications  I stumbled upon your web site and find it useful.
- David Cramton
Microsoft Excel VBA - Visual Basic for Applications  I have been avoiding performing standard deviation analysis for years. Your advise has greatly helped me understand the process. Thanks.
- Debra Gardner
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,

...

I had found your site when searching through Yahoo ... the site is very well laid out and helpful.
- Bob Gowens
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

...

Thanks for the web page. I found it very helpful.
- Guang Tong
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney

I am now using the drop down list you described on your site. Thanks for that.

...

Cheers,
- Iain Smith United Kingdom
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,

I'm enjoying your website with all the spreadsheet formulas ...

Thanks for your help,
- Anthony
Microsoft Excel VBA - Visual Basic for Applications  Hi my name is Thomson and I found the tips on your Excel sheet very interesting.
- Thomson Mathews
Microsoft Excel VBA - Visual Basic for Applications  Hello Rodney:

I've enjoyed your helpful hints and tips ...
- Gerry Fitzgerald [Halliburton]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Hi there,

I was interested in your little article related to Dynamic Named Ranges, which leads me to ...

Cheers,
- Jim Carter Australia
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,

Love your website! ...
- Lindy WIlliams [Vodafone] Australia
Microsoft Excel VBA - Visual Basic for Applications  Your website has been of greate help. I was delighted to find your charting procedures for dynamic data ...

Thank you,
- David Noto
Microsoft Excel VBA - Visual Basic for Applications  Dear Experts,

... This is such a great website ...
- Sue
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  I was looking online for an anwer to an Excel question and came across your site. Very impressive!
- Richard Murray [Carrier Sales]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Your web site is excellent.
- Trevor McCarthy [BP Amoco] Queensland, Australia
Microsoft Excel VBA - Visual Basic for Applications  Thank You for your help.

...

Again thanks for your help. I learned something useful.
- Rick Parkinson
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Rodney -

I appreciated your dynamic named range explanation ...
- Jim Shoenfelt [AmTrust Services]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  I stumbled onto your site and I think it is awesome!!
- Paul O'Connor Canada
Microsoft Excel VBA - Visual Basic for Applications  Thanks for the wonderful tips on using array formulas.
- Carol Maharaj [Litton]
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

I read your solution to charting dynamic data and found it very interesting. ...

Thanks,
- Paul Watson
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,

I visited your site and I am quite impressed ...
- Greg McDonald [Ingersoll-Rand] Huntersville, NC
Microsoft Excel VBA - Visual Basic for Applications  Your clear explanation is much appreciated! Do you have similar livesavers for Access?
- Jane Hunter
Microsoft Excel VBA - Visual Basic for Applications  Thank you for the Excel tip on preventing duplicate entries. ... a nice simple solution that will help me with some inventory control.
- Brian Fisher
Microsoft Excel VBA - Visual Basic for Applications  ... I found your web page and what great information ...
- Gerri Johnson
Microsoft Excel VBA - Visual Basic for Applications  How about class modules for mere mortals?

Just a suggestion. Enjoy your tips.

Cheers,
- David Phares [Borland]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  I was looking at your site and see that it has a lot of very useful information ...
- Dean Sandvig [Kimberly-Clark Corporation]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Excellent newsletter. Please keep it coming. I send referrals to my students.

...
- Kimberly Mills [Aries Training Associates]
Microsoft Excel VBA - Visual Basic for Applications  Hello:

I have been just recentyl introduced to this site and already have learned a great deal. Keep up the good work.

...
- anonymous
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  First of all thanks for some great tips, I've found lots of handy things on the site.

...
- Raoul Federman [Heron Corporation] London, UK
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  ... I do want to thank you for the great resourceful website.

Best Regards,
- Yee-Bien "Aimee" Chuah [David Weekley Homes]
Microsoft Excel VBA - Visual Basic for Applications  Did a great job of explaining the drop down list. ...
- Bill Vidacovich
Microsoft Excel VBA - Visual Basic for Applications  Hello Rodney. I have picked up very useful tips from your website. Many thanks. ...
- Chuck Harkes
Microsoft Excel VBA - Visual Basic for Applications  ...

I did look through your site and really like the information that you provide!

...
- Joe Witte [PG&E National Energy Group]
Microsoft Excel VBA - Visual Basic for Applications  Congratulations for the web site : design and content are equally outstanding.

Regards from beautiful Belgium,
- Hervé Hanuise [Affordable Solutions] Belgium
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Firstly, may I say congratulations on your site - it contains may useful tips. ...
- Ananda Gunasekera Australia
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Is awesome

Thanks for the tip!
- Jason Cumberland [KPMG Consulting]
Microsoft Excel VBA - Visual Basic for Applications  Thanks for providing some great examples of Excel's advanced capabilities!!
Microsoft Excel VBA - Visual Basic for Applications  Thank you for your updates.

...
- Loretta Melnychuk [ExxonMobil]
Microsoft Excel VBA - Visual Basic for Applications  I love your site. Thank you.

Regards & Best Wishes,
- Roman Mesina [Windward Capital, LLC]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Rodney, your help on adding time values was invaluable to me ...

...

Thanks
- Kris Wright
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Ladies & Gentlemen,

Great site you have there. ...
- Russell Williams
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Good morning Rodney,

Thank you for the tips they prove to be v. handy

...
- Karin Wightman
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Thanks for your Excel tips. Every month I learn at least one thing new.

...
- Scott Haralson [America West Airlines]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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á
Microsoft Excel VBA - Visual Basic for Applications  Hello:

I appreciate your tips on Excel. They have been very useful to me.

...
- Doug Gaynor [Carson Oil Company]
Microsoft Excel VBA - Visual Basic for Applications  Hi,

I just wanted to say thank you for your Excel tips. I appreciate the free help very much.

Sincerely,
- Steven Gravino
Microsoft Excel VBA - Visual Basic for Applications  ... Keep up the great work.

Regards
- Alex
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Thanks.

I think I got it.
- JR Wehrmeister
Microsoft Excel VBA - Visual Basic for Applications  Thank you for the updates.
- Michael Boyd [ATLIS Systems]
Microsoft Excel VBA - Visual Basic for Applications  Hello,

I get your news letter and enjoy seeing all the cool VB stuff. ...
- Peter McAlenney [MFG, Inc.]
Microsoft Excel VBA - Visual Basic for Applications  Thank you and I look forward to your mail. ...
- Dan Sasser [Universal Corporation]
Microsoft Excel VBA - Visual Basic for Applications  ... love your work
- Kitch Morris
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Great article on a neat feature (dropdown listbox). ...
- Vernon Huff
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Thank you very much. ... This will be easy now.
- John Stec
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  ...

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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  ...

I enjoy your newsletters and look forward to more tips.

Thanks.
- Nick Feller [Feller Consulting] Englewood, Colorado
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Hi Guys

Love your useful excel info.

...

very much appreciated
- Amanda Askew Australia
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Information on the Beyond Technology site is superb! Compliments. ...

Greetings,
- Anonymous
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Excellent Page
- Marcos Oyola [PB International]
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,

I admire your contributions and the entire site!

...

Thanks alot!
- Sam ElAssaad Santa Clara, California
Microsoft Excel VBA - Visual Basic for Applications  [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
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney

First of all I would like to thank you for the real good excel tips! they are really useful.

...

Regard
- Subodh Gupta
Microsoft Excel VBA - Visual Basic for Applications  Rodney...

Like the useful VBA stuff on your site...
- R.J. Harrison
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Great to hear from you again! These tips are always a great help, Thank you.
- Timothy Furguson [K2 Corporation]
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Thankyou!!!
- Charmayne Paul
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Thank You.
- Kitt Langkilde [After Hours]
Microsoft Excel VBA - Visual Basic for Applications  This is a wonderful service. Are back issues available?
- James Greene [JimCo]
Microsoft Excel VBA - Visual Basic for Applications  Heard about this from my college algebra professor who loves Excel and uses it like a wiz.
- Joanne Worcester [Law Dept.]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  Thanks for your tips.
- Antonio Morales [M Najar, SA]
Microsoft Excel VBA - Visual Basic for Applications  Great Site
- Wade McDowell [Rural Telephone]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Great site. I found the answers to questions I had within 5 minutes. The quarters calculation is very handy.
- Hamish MacPherson [ANZDL]
Microsoft Excel VBA - Visual Basic for Applications  Chance find - very impressive - two invaluable tips.
- Greg Marsh [Global Freight Exchange]
Microsoft Excel VBA - Visual Basic for Applications  VERY USEFUL
- Vidyapathy Na [Akmit]
Microsoft Excel VBA - Visual Basic for Applications  I searched for help re: how to start using VBA (in Excel). This site has been VERY helpful. Thanks!
- Allan Pentecost [Intel]
Microsoft Excel VBA - Visual Basic for Applications  The YTD-offset function was very helpful, thanks
- Marco Plandsoen [Fenestrae B.V.]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Found you while surfing -- I think you're wonderful!!
- Carol Welch [The Container Store]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Thanks for such great tips.
Congratulations on this quality, well-structured, user-friendly site.

Regards,
- Al DePalma [W.R. Grace]
Microsoft Excel VBA - Visual Basic for Applications  Wow, this is great information.

Many thanks for having this available. Easy to read and understand
- Sheryl Goad
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Hi there Web Master

I have just visited your site and I am quite impressed with its details and offerings.
- Nathan Johnson
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,

I like your site. It's well done and helpful !

...

Thanks,
- Russ Reimann
Microsoft Excel VBA - Visual Basic for Applications  Thank you for the tips. I was able to put them to good use immediately.
- Elisabeth Snyder [New York Life]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,

I like your site. It's well done and helpful !

...

Thanks,
- Russ Riemann
Microsoft Excel VBA - Visual Basic for Applications  Have you given any thought to publishing your tips in a PDF?

Excellent tips....thanks much for helping us all.
- G. Hancock
Microsoft Excel VBA - Visual Basic for Applications  Your advices are great

Thanks
- Niko Osolnik
Microsoft Excel VBA - Visual Basic for Applications  Thanks !
- Jailson Castilo [V.I.]
Microsoft Excel VBA - Visual Basic for Applications  Thanks for the fast response and the help you and your site help out a lot!!!
- Aaron
Microsoft Excel VBA - Visual Basic for Applications  Thank you
- Tamas Becsak [Honeywell Kft]
Microsoft Excel VBA - Visual Basic for Applications  ... These are wonderful ...
- Kara Mullaley [Corning Cable Systems]
Microsoft Excel VBA - Visual Basic for Applications  Very helpful.
- Christina Au [Ngai Hing Color Technology Co., Ltd.]
Microsoft Excel VBA - Visual Basic for Applications  Site is good!
- Badri Srinivasan [Meenakshi Computers Limited]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Your pages on Tips, VBA, and Geeks are well done and very helpful. Thank You
- Daniel Belisle
Microsoft Excel VBA - Visual Basic for Applications  Great site - thank you
- Monty Wood [Amber Business Computers]
Microsoft Excel VBA - Visual Basic for Applications  I like your site very much. It's not cluttered like so many (i.e. MSN). ...
- Charlie White [ELI Inc]
Microsoft Excel VBA - Visual Basic for Applications  The online tips are great. I'm looking into VBA as a new hobby/career development interest. Thank you.
- Curtis Childers [Agribuys]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  You've got some really good ideas there.
- Murray Clark
Microsoft Excel VBA - Visual Basic for Applications  The tips were very helpful so far on a complicated project for one of my clients. Thank you.
- Tony Worley [Computer Consulting] McAllen, TX
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  More Excel spreadsheet power tips - they're great!! Thanks!
- Angela Abruzzese [Capital Cargo International]
Microsoft Excel VBA - Visual Basic for Applications  Very interesting
- Enzo Spinaci [Focus Group S.R.L.] Italy
Microsoft Excel VBA - Visual Basic for Applications  I'm subscribing! Just fabulous. Your instructions and visuals make everything so understandable. Thanks so much!
- Penny Maggio [Defense Supply Center Richmond]
Microsoft Excel VBA - Visual Basic for Applications  Thanks - this is great.
- Mary Pidgeon [BAS Analytics]
Microsoft Excel VBA - Visual Basic for Applications  Great looking site. Fantastic examples. Goes to the top of my recommended sites for VBA.
- Lee Hibbert
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Rodney:

Thanks for the advice and taking the time to answer. I really appreciate it.
- Will Perry, CPA [Bridgestone/Firestone, Inc.]
Microsoft Excel VBA - Visual Basic for Applications  Thanks for your help, I really appreciate it.
- Chris Acimovic
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  This site is excellent! Kudos to Mr. Powell!!!
- Ed Destura [Eman]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Thank you very much for this wonderful site ...
- Muhammad Dawood
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Thanks for the weighted average explanation and examples ... it was TONS of help!
- Paul Plodzien [General Motors Corporation]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Great site. I was actually looking for a solution to find the last row. Thanks for all the tips.
- Sam Varadarajan [Covansys]
Microsoft Excel VBA - Visual Basic for Applications  I can use this to help with my books. Thank you.
- Danny Wilson [Dan's Apple Farm]
Microsoft Excel VBA - Visual Basic for Applications  Thanks for the excellent tips that this site offers for Excel Users.
- Reg Vaz [Business Solutions]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Thanks I enjoy your input.
- Walter Goeken [R Goeken Farms]
Microsoft Excel VBA - Visual Basic for Applications  Thank you in advance
- Ian Grant Pitman [Project Economics International]
Microsoft Excel VBA - Visual Basic for Applications  This site is much more helpful than Microsoft's own Excel help utility. Thanks!
- Paul Mayes
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  This site is really helpful.
- Joju Joseph [Mecklai]
Microsoft Excel VBA - Visual Basic for Applications  Thanks a lot for the help - looking to learn much more about VBA for Excel
- Alan Stigall [Creative Designs]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Great site, learning a lot. Thanks
- Paul Anceau [The HouseCoat Company]
Microsoft Excel VBA - Visual Basic for Applications  Hi!

...

I like this site. Cheers. Thanks.
- Kamlesh (KAM) Trivedi [Omnicom Services]
Microsoft Excel VBA - Visual Basic for Applications  This is good stuff for us novice Excel users who desire to become upper echelon users ...
- Patrick Bowland [Engage Energy US LP]
Microsoft Excel VBA - Visual Basic for Applications  Fantastic site !!!
- Armando Valdes [CT Corporation]
Microsoft Excel VBA - Visual Basic for Applications  Dear Sir,

I am impressed with your web site and Excel tips.
- Jagdish Shah
Microsoft Excel VBA - Visual Basic for Applications  Nice web page.
- Rafal Kacprzak [BRE Leasing]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Thanks for spreading the knowledge!
- Clinton Lee [Ugly Duckling]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  nice page
- Martin King [Wirral Metropolitan College]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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. ]
Microsoft Excel VBA - Visual Basic for Applications  I've enjoyed looking at your site and learned a couple of useful thing.
- Roo Davison [Terradigm, Inc]
Microsoft Excel VBA - Visual Basic for Applications  Love your website -- excellent real world examples ...

thanks,
- Mike Cooper
Microsoft Excel VBA - Visual Basic for Applications  Thank you
- David Lanman
Microsoft Excel VBA - Visual Basic for Applications  Great information on your site.
- Ron Petitt [Software & Services]
Microsoft Excel VBA - Visual Basic for Applications  THANK YOU!!! IT WORKED!!!

-----

Thank you for responding and so quickly.

...

Thank you!
- Donna Smith
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  Thanks..
- Eduardo Carrasco [APR]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  I like your website. Good information for an Excel hack like myself.
- Cliff Merritt [AMEC E&C]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  You seem to have some useful solutions, so I'd like to see more.
- Eugene Larkin [U.S. Air Force]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Thanks!
- Amy Hawbaker [Survey Sampling, Inc. (SSI)]
Microsoft Excel VBA - Visual Basic for Applications  Thanks - This is very helpful!
- Lou Cioletti [U.S. National Aeronautics and Space Administration (NASA)]
Microsoft Excel VBA - Visual Basic for Applications  Rodney, great job on the website and enjoying the tips...keep them coming.
- George Willis [Fayez Sarofim & Company] Houston, TX
Microsoft Excel VBA - Visual Basic for Applications  Thank you for a wonderful newsletter.
- Wayne Noble [M-Web]
Microsoft Excel VBA - Visual Basic for Applications  Thanks Rodney,

This looks like some excellent information. I'm going to spread it around a bit.
- Dede Burum [Booz Allen & Hamilton]
Microsoft Excel VBA - Visual Basic for Applications  Please keep up your very good work.
- Edgardo Noriega [Edgar Inc]
Microsoft Excel VBA - Visual Basic for Applications  Thank you for the newsletter the tips are great!
- Gabe Cote [Aqua Measure]
Microsoft Excel VBA - Visual Basic for Applications  Many Many thanks for your newsletter. I learn the most from it.

...
- Don Guillett [SalesAid Software] Granite Shoals, TX
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Hello Rodney,

... your newsletters are really very helpful - thank you !
- Stephen Ashley
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Thank you, kindly. I will find many uses for this!
- John Brizek
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  Thanks for helping me. This page is very interesting.
- Franz Cardenas [FraMa Sowtwares Ltd]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Very useful tips and tricks!
- Nagnus Olofsson
Microsoft Excel VBA - Visual Basic for Applications  I'm delighted!
- Jal Nouda
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Thank you for this mavelous resource.
- Susan Melifonwu [U.S. Patent and Trademark Office]
Microsoft Excel VBA - Visual Basic for Applications  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)]
Microsoft Excel VBA - Visual Basic for Applications  Really interesting procedures - and they work!
- Joan McCudden [Marsh Management Services Ltd] Dublin, Ireland
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  I am excited about it.
- Tersam Heer [Fairway]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Rodney

Your monthly newsletter is extremely beneficial and insightful. I thoroughly enjoy reading it.
- Brad Firsich [Franks Industries, Inc.]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Loved the newsletter (I just signed up). ... goes on to offer an excellent Excel tip
- Ashley Williams [Continental Airlines] Houston, Texas
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,

...

Brilliant website by the way - it's my Excel bible-on-the-web!

All the best,
- Karen Alston [CPM International] United Kingdom
Microsoft Excel VBA - Visual Basic for Applications  Hi there

Great homepage!

... goes on to offer an excellent Excel tip

Kind regards
- Jan Vogt Hansen [Maersk Contractors] Denmark
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Thanks, I do like your work and effort.
- Carlos Gonzales [GSA Computer Enterprises, Inc.]
Microsoft Excel VBA - Visual Basic for Applications  I found your website very helpful. I am particularly interested in the VBA language.
- Deborah Esegbona [Ese's House Ltd]
Microsoft Excel VBA - Visual Basic for Applications  I found this site and I think it is great !!!
- Leigh Toth [HMS Host]
Microsoft Excel VBA - Visual Basic for Applications  I appreciate this. It is quick, to the point, and provides avenue to further information.

GREAT JOB.
- Jim Brunick [Lockheed Martin Aeronautics Company]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

I found this very helpful.

Thanks
- Rich Guard [Teradyne, Inc.]
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  Keep up the good work!
- Daniel Ward [Dominion Virginia Power]
Microsoft Excel VBA - Visual Basic for Applications  ... Great newsletter, keep it up!!

Best Regards
- Tim Key [Air Logistics, Inc.]
Microsoft Excel VBA - Visual Basic for Applications  Cool! Thanks!
- Cindy Prestidge [Hewlett-Packard Company]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

... I want to thank you very much and I look forward to receiving additional mailings.

Best regards,
- Maurice Hevey [Convergent Cosmetics, Inc.]
Microsoft Excel VBA - Visual Basic for Applications  Thanks
- Randy A. Shively
Microsoft Excel VBA - Visual Basic for Applications  Thanks!
- Roy Long [U.S. Department of Energy (DOE)]
Microsoft Excel VBA - Visual Basic for Applications  Thanks for the tip ...
- Oliver Karp [Interviewing Service of America (ISA)]
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Thank you, it worked.
- Paul Scovill [Catholic Youth Council]
Microsoft Excel VBA - Visual Basic for Applications  Rodney

Thanks for the EXCEL Solutions Letter ...
- Joe Knofczynski [U.S. Army]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Thank you very much for the letter ...
- Luis Alberto Román [Mirasol S.A.]
Microsoft Excel VBA - Visual Basic for Applications  ...

Thanks a lot.

Sincerly
- Jefferson Hoyos [El País S.A.]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Thank U
- Vishwanathan Ns [Weizmann Ltd.] Fort, Mumbai
Microsoft Excel VBA - Visual Basic for Applications  Thanks

This may be very helpful.

Thanks a lot.
- Larry Belk [Union Tank Car Company]
Microsoft Excel VBA - Visual Basic for Applications  Rodney,

Thanks for including me on the mailing list for the Excel Solutions Newsletter.

...
- Steve Abbott [Duke Energy]
Microsoft Excel VBA - Visual Basic for Applications  This is cool - thanks.
- Vu Nguyen [MidAmerican Energy Company]
Microsoft Excel VBA - Visual Basic for Applications  Thanks and very nicely navigated Web site.
- Alan Villiers [Harry S. Truman Memorial Veterans Hospital] Columbia, Missouri
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Thanks and I really enjoy the newsletter.
- Gary Smith [City of Sierra Vista, Arizona]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  I've used several of your tips and procedures and have saved enormous amounts of time. Thanks.
- Dennis Butler [ATR Distributing]
Microsoft Excel VBA - Visual Basic for Applications  Keep up the great work and thank you.
- Robert Westin [Major Dynamics]
Microsoft Excel VBA - Visual Basic for Applications  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
Microsoft Excel VBA - Visual Basic for Applications  Thanks, great site.
- Dave Hawley [OzGrid Business Applications] Australia
Microsoft Excel VBA - Visual Basic for Applications  Thanks for the VBA samples! They saved me a lot of time.
- Ian Goodsell [Compuware]
Microsoft Excel VBA - Visual Basic for Applications  Found you on a random search of the Web. Excellent tutorial - thank you.
- Ewen Sim [NW Regional Action Team]
Microsoft Excel VBA - Visual Basic for Applications  Thank you for the service.
- Paul Shaw [PCD Training]
Microsoft Excel VBA - Visual Basic for Applications  Your newsletter is awesome!!
- Scott Senffner [Central Enterprises]
Microsoft Excel VBA - Visual Basic for Applications  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.]
Microsoft Excel VBA - Visual Basic for Applications  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]
Microsoft Excel VBA - Visual Basic for Applications  Hi Rodney,