Excel

EXCEL VBA: THE MARCO TO COPY DATA TO MERGED CELLS

Feb 13, 2021 · 6 min read · Excel VBA HOMEMADE ·

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE In Excel, when copying data from normal cells to merged ones, …

EXCEL VBA: YOU MAY HAVE A ERROR ON CHANGING PRINTAREA DYNAMICALLY & HOW TO AVOID IT

Jan 15, 2021 · 5 min read · VBA Excel ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE You may want your implementaion to change print area of a …

EXCEL VBA: A MACRO TO SEARCH AND REPLACE A TEXT OF SHAPES IN EXCEL BOOK

Dec 11, 2020 · 5 min read · Excel VBA ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE Hi, I'm Dede. Here I introduce a macro to search and replace a …

EXCEL VBA: TYPICAL PATTERNS FOR EXCEPTION HANDLING & SAMPLE OF HOW TO USE

Dec 5, 2020 · 12 min read · Excel VBA HOMEMADE ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE In programming, it's a general implementaion to do special …

VBA: THE BENEFIT OF USING CLASS AND THE WAY TO USE, WITH A SIMPLE SAMPLE PART 2

Nov 22, 2020 · 9 min read · Excel VBA HOMEMADE object-oriented ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE Hi, I'm Dede. This article is a a sequel of a article I posted …

VBA: THE BENEFIT OF USING CLASS AND THE WAY TO USE, WITH A SIMPLE SAMPLE PART 1

Nov 20, 2020 · 6 min read · Excel VBA HOMEMADE object-oriented ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE Class in VBA is kind of minor and somehow hard-to-use than any …

EXCEL VBA: HOMEMADE EXCEL SHORTCUTS TO IMPROVE WORK EFFICIENCY

Nov 5, 2020 · 6 min read · Excel VBA homemade ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE I think there are quite a lot of cases to post text from Excel to …

EXCEL VBA: WITH POLYMORPHISM, BRANCHING A PROCESS WITHOUT USING IF STATEMENT

Nov 1, 2020 · 5 min read · Excel VBA HOMEMADE object-oriented ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE Hi, I'm Dede. Here I introduce a sample of coding based on a …

EXCEL VBA: I CREATED A TOOL THAT ALL SELECTED EXCEL BOOK HAVE THEIR CURSOR MOVED TO A1.

Nov 1, 2020 · 1 min read · Excel VBA HOMEMADE tool ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE This tool will free the user the hassle of having to move a …

[EXCEL] I CREATED A MAIL CREATION TOOL WHICH IS NON-MACRO.

Jul 18, 2020 · 1 min read · Excel tool automation HOMEMADE ·

Share on:

Help me improve my English! As you probably see, I'm not a native English speaker. If you find an English expression that feel incorrect or awkward, please let me know. Message box of Disqus is under the article. Or my E-Mail is here. ABOUT THIS ARTICLE This article describes a Non-VBAMacro Excel tool I created …