I do not know why this does this. But I was able to work around the problem. Please try this...
Maybe try declaring the FSO as Object. "Dim FSO" without a declaration declares the FSO as a variant. Just a...
Each block is a named range. There are 6 Key colors which are based on the information in column “Y”(Rental...
I cleaned up the code. This will place next month and year in cell A1. So today is Sep30 2018...
This was tested in a blank worksheet (no data). The macro will place next Month and Year in cell A1....
Updated the code to include the possibility of blank cells in the raw data. If a blank cell is found...
Lets try this again. You will need 3 sheets. Sheet1, Sheet 2 and Sheet3 Sheet1 your raw data Sheet2 is...
Hey Thank you so much. Apologies for not been very clear on the question. Using your example, in the output...
Please read this Agreement carefully before using the Website (Blog or Question & Answer Forms). By accessing or using any part of the website, you agree to become bound by the terms and conditions of this agreement. If you do not agree to all the terms and conditions of this agreement, then you may not access the Website (Blog and Question and Answer Forums).
If you create an account on Analysistabs Website, you are responsible for maintaining the security of your account and you are fully responsible for all activities that occur under the account. You must immediately notify Analysistabs of any unauthorized uses of your account or any other breaches of security. Analysistabs will not be liable for any acts or omissions by you, including any damages of any kind incurred as a result of such acts or omissions.
We thought this is necessary because a few of the members who come to our Blog/ Question and Answer Forums to find the solutions or answer the questions, and post threads without thinking, and without realizing that there is no possible way they could get help because of the way they posted the question. Here are some general guidelines.
There is a pretty good chance that unless you have some really odd or unique problem that it has been addressed on our forum before, please use the forum’s search feature first to see if there are already some good threads on the subject. It’s easy to search – just enter your question on the searchbox at the top of the page and press enter key.
Post a descriptive topic name! Give a short summary of your problem, add some screen-shots to make others to understand your questions.
Here’s a stupid list of topic subjects YOU SHOULD NOT POST:
Hi, Hello, Please Help Me, Very urgent, I have a question, I need your help,Excel Formula?,VBA?
ANYTHING similar to above statements is unacceptable. Please post your problem.
Here is a good example of a way to post a question:
“How to find the sum of sales using Excel Formula?”
“What are the advantages of using Option Explicit in VBA”
When asking a question and answering a question. please do not add to the existing question post. Please create a new question, so that will be on top of the forum question list and get answered quickly.
Remember when people help you, they are doing YOU a favor, So:
Be patient, help people out by posting good descriptions of what you need help with, and do not show your anger on other members.
These forums define spam as unsolicited advertisement for goods, services and/or other web sites, or posts with little, or completely unrelated content. Do not spam the forums with links to your site or product, or try to self-promote your website, business or forums etc.
Spamming also includes sending private messages to a large number of different users.
DO NOT Post or ASK for email addresses or phone numbers
Your account will be banned permanently and your posts will be deleted.
Providing or asking for information on how to illegally obtain copyrighted materials is forbidden.
Any material which constitutes defamation, harassment, or abuse is strictly prohibited. Material that is sexually or otherwise obscene, racist, or otherwise overly discriminatory is not permitted on these forums. This includes user pictures. Use common sense while posting.
This is a web site for accountancy professionals.
Please refrain from posting the same question in several forums. There is normally one forum which is most suitable in which to post your question.
Please respect your fellow users, staff, and moderators. We are all part of one community and you are expected to treat all users in a professional and respectful manner. You may have every right to disagree with your fellow community members and explain your perspective. However, you are not free to attack, degrade, insult, or otherwise belittle them or the quality of this community. It does not matter what title or power you hold in these forums, you are expected to obey this rule.
If you break a rule, then you will either be banned without any notice. The administrators and moderators also have the right to edit, delete, move or close any thread or post as they see necessary, without prior warning.
Please report the thread/post to the moderators or admin.
All moderator applicants must be an active member for at least 100 days and have at least 100 posts. Please be aware that applying to be a moderator does not guarantee acceptance and that moderators will only be appointed when needed. Administrators will review applications and decide if the applicant fits the desired post, and reserve to right to refuse applicants with or without cause.
The Terms of Forums Rules can be changed through time, so you should check this page from time to time for any possible changes that have been made. Any major changes will be covered in our blog.
The Terms of Service are effective from August 1st Jan, 2014.
ANALYSISTABS.COM reserves the right to terminate any member account without notice. There are no excuses for breaking the rules. It doesn’t matter if you were angry at the time and weren’t thinking straight. It doesn’t matter if you were only kidding around. If you break a rule, it does the same damage, regardless of your reasons for breaking it, and you will be punished all the same.