Check if cell is not empty and checks if worksheets already exists

I have three worksheets in a workbook namely "Client", "Collections" & "Interest". I want to use data from these worksheets to create new worksheets and also populate the corresponding values. As a start i manage to create new worksheets but it is also creating worksheets with no tab name. Please help me fix this:

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Note that I am answering in post edited by arlu1201. She added code tags as required by forum rules - please follow our rules in the future.

creating worksheets with no tab name

This leads to conclusion: Probably not empty but with space or other nonprinting character. So let;s try to get rid of it with function trim.

Please Login or Register  to view this content.

I made some other minor corrections - check if they work right.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

PS. I Assume that A1 in a comment is less important than B6 in code

Modified to so that printing on B6 only applies to new worksheets

Please Login or Register  to view this content.

Please Login or Register  to view this content.

I kindly tried to focus your attention to code tags use:

Note that I am answering in post edited by arlu1201. She added code tags as required by forum rules - please follow our rules in the future.

As you do not care, I am reporting your post. Wondering why? see rule 3 in http://www.excelforum.com/forum-rule...rum-rules.html

Thanks Kaper.

rskay14

Welcome to the forum. Pls take some minutes and read forum rules. In your first post, Admin added code tags to your code, asking next time to do yourself. Seems that you choose to ignore that kind warning. So to make it more clear.


Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here



(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)