VBA macro to delete empty columns in excel

Excel VBA macro to delete empty columns. Just run this macro, enter number of columns you want to check and the macro checks (starting from first column) and deletes all empty columns within the selected number of columns. In the macro, you can also find VBA syntax to delete empty row and to check whether a […]

2 easy ways to compare cells string data in excel

This article explains how to compare two cells of text string value. There are two easy ways to compare the cells having text strings in excel. Using EXACT function This function compares two text strings and returns TRUE if they are exactly equal, FALSE otherwise. EXACT function does case sensitive comparison/match i.e. it treats Why […]

Check if a cell value contains capital letter in Excel

excel-function-to-check-cell-contains-capital-letter

If you want to check if a cell value (text string) contains at least one uppercase letter in excel, then use below function. =NOT(EXACT(LOWER(A1),A1)) Note: A1 is the cell number Above function returns TRUE if the cell value contains atleast one uppercase letter FALSE if the cell value has all lowercase letters         […]

VBA macro to remove duplicates from each column [Excel]

vba-macro-remove-duplicates-each-column

VBA macro to remove duplicates from each individual column in excel sheet. This simple macro,  just single line syntax, treats each column as a separate entity and removes all duplicates from each column and keeps only unique values. VBA macro code to remove duplicates from each column

If you want to remove duplicates from a single column, […]

Simple steps to delete or uninstall WordPress theme

uninstall-delete-wordpress-theme

Below are the simple steps to delete or uninstall wordpress theme. Note: Make sure you have one active theme before deleting unnecessary free themes. Steps to delete or uninstall wordpress theme Login into your WordPress site On left side, click on Appearance -> Themes You will see all the themes installed on your WordPress site Hover […]

Block user agent libwww-perl to improve wordpress site security

Libwww-perl is a user agent that is commonly used by hackers to attack on your site. Libwww-perl are botnet scripts that look for vulnerabilities in your software. We should block them to eliminate attacks on your site which improves your site security. It is very simple to block user agent libwww-perl Copy below two lines and […]

NoIndex Feedburner feed to avoid duplicate content

feedburner-feed-noindex-search-engines

If you are getting your Feedburner feeds in search engine’s search results, it means your feed is indexed by them. You may get ‘duplicate content’ issue and It is bad for your site SEO. Below are the simple steps to prevent or noindex feedburner feed from being indexed by search engines. Steps to NoIndex your […]

Best wordpress plugin to clean and optimize database

wordpress-plugin-delete-orphan-options-tables

When you uninstall a plugin/theme on wordpress, either manual or automatic, many times it doesn’t get removed completely. Some support files of that plugin/theme/app still left in your wordpress MySQL database. They don’t serve any purpose as their parent application (plugin/theme) is uninstalled. As your site gets older, you may install and uninstall many plugins and […]

Page 5 of 13« First...34567...10...Last »