About > AllExperts  
Search for
  Main Menu Ask a Question Browse Past Answers Meet Top Experts Be an Expert Login (Experts Only)
About Us  ·  FAQ  ·  Tell Friends About Us  ·  Link To Us  ·  Free Encyclopedia  ·  Disclaimer  ·  Tech Support   
  You are here:  AllExperts > Computing/Technology > Business Software > Excel

Expert Profile: Bill

Expertise:  I can provide help with most all EXCEL questions and most all questions about writing EXCEL macros. I have been developing macros for about 10 years in EXCEL and have switched to it from Lotus 1-2-3 after about 10 years of writing macros in it. Typically, I will not write a macro for you unless it is very short because of all the details a macro has to know about to work every time all the time. Please understand that I do not know it all and will be the first to say so. As politely as possible, I don't write macros for people on this site who need one, want one, seem to imply that they need one, and/or seem to think I am expected to write one UNLESS they are very short, quick, and simple. 99% of all macros are more involved than what you think and rarely am I provided with enough specific and complete details to have the code work the first time and every time. This typically means too many follow-up emails, and subsequent macro changes due to lack of specific details, just to get those details so that the macro would work, all of which is on my own free time. The voice of experience from responding to many questions from people who ask me to write a macro for them from this site tells me this. I don't mean to come across as unhelpful but macros are usually very specific and without ALL of the specifics the macro I would write will not address all of your needs and the layout, location, formatting, conditions, etc. of your data and any related files the macro would have to work with. What seems like a simple task to you is almost always more involved than what you think to have the macro ALWAYS work in EVERY situation. If you have a macro you have already written and have a question about it then perhaps I could help with that. I am sure and hope you can and do understand.

Ask a Question       View Past Answers       View Ratings            
Average Ratings
Prestige Points: 45350
Knowledge   9.78   Best of the best
Clarity of Response   9.64   Best of the best
Timeliness   9.93   Best of the best
Politeness   9.70   Best of the best
Number Of Questions
(in Past 24 Hours)
2
Max Questions to be Asked
(in 24 Hour period)
9
Total Questions
(since joining AllExperts)
8448
Recent Reviews from Users
KnowlClarityTimePolitenessDate
1010101011/20/08
1010101011/19/08
1010101011/17/08
1010101011/16/08
1010101011/13/08
User Comments
would have more benifited if been provided with macro program
(Abhijin on 11/19/08)
Bill, your simple, straight-forward answer is the perfect response to my problem. Thank you very much. Bob Kunz
(Robert on 11/17/08)
Thank you very much. I will re-evaluate my situation and look for other alternatives.
(Kami on 11/13/08)
View All Comments
Ask a Question       View Past Answers       View Ratings            

Recent Answers from Bill
2008-11-19  Search Cell Any Word I can't tell exactly what you are asking for since you have included the entire thread with your comments and the replies. What do you need? And please include the thread too so I can follow what has...
2008-11-19  Securities in Macro Sorry, as politely as possible, I don't write macros for people on this site who need one, want one, seem to imply that they need one, and/or seem to think I am expected to write one UNLESS they are very...
2008-11-18  Excel macro buttons Not really. Code can be written and more correctly, "set up", to run automatically. In your case, the macro would be tied to a cell changing or a different cell being selected. But, you will have to...
2008-11-18  find new claimants Sorry, as politely as possible, I don't write macros for people on this site who need one, want one, seem to imply that they need one, and/or seem to think I am expected to write one UNLESS they are very...
2008-11-18  Macro to copy and transpose text based on criterion OK, so, what's your question? If you mean by "looking for a macro" that you want me to write it for you then sorry, as politely as possible, I don't write macros for people on this site who need one,...
More Answers for "Excel"


Advertise on This Site | User Agreement | Privacy Policy | Kids' Privacy Policy
Copyright  © 2008 All rights reserved. AllExperts is a property of About, Inc.
The About logo, About and About.com are registered trademarks of About, Inc.