Some Excel functions may apply to specific subject areas, while others are general and can be applied to all needs. The following shows a li...

If you're working on a project or having a numerous reports in excel to be sent out to your boss or clients. And what you usually do is ...

Some Excel VBA developers are protecting their codes and modules with password in order not to let others view the content of their project....

I'll be showing you an example on how to Scrape Data from a Website into Excel Worksheet using VBA. We'll be scraping data from www(...

You might be working on a project where you need to filter sets of data and create a raw data of that filtered sets of data to a new shee...

The following function below allows you to get the number of visible rows from a filtered sets of rows in Excel using VBA. The function t...

The following function allows you to get the Address of each visible rows from a filtered sets of data in Excel using VBA. [ VBA ] Dim Fi...

Named Ranges in Excel enable you to give one, or a group of cells a name other than the default B4 for a single cell, or B2:E20 for a range...

There are 7 Named Range Rules that we'll be tackling in this tutorial. 1) You can set a Named Range to have the scope of a single ...

The following FindandReplace() funciton allows you to replace or remove specific text and characters you want in Microsoft Excel. Just copy...