VBA Codes to Highlight Duplicate Values in Excel

While working with huge data, duplicate values are always a concern. Most of the time I use remove duplicate option to remove all those values.And, I’m sure you do the same.But, removing these duplicate values or just counting them never sort out the problem. The important thing is to review all the duplicate values before […]

Top 5 Methods to Remove First Character from a Cell in Excel

Yesterday, one of my colleagues, who is really passionate to learn Excel these days asked me this:“Do you know how to remove the first character from a cell in Excel?”I told him a small formula (which was easy) for that, but he was not satisfied and want another method.And after that, I told him about […]

How to Extract Hyperlink Address (URL) in Excel Using VBA UDF

Let’s say you got an Excel workbook from your colleague where you have a list of hyperlinks in a column.Now from this list, you want to extract all the hyperlink URL addresses.The manual method is a real pain, you need to copy-paste each URL one by one.So the better way is to create a UDF […]

How to Highlight Dates Between Two Dates

You have dates in column and you want to highlight all the dates which are between the range of two dates.Huh?OK, alright!Let’s say you have a start date 17-Jan-2017 and an end date 19-Mar-2017, and from the dates column, you want to highlight all the cells in which date is between these two dates.For this, […]

How to Create a Data Validation with Date Range

Let say you need to create a data validation for dates in which you want to use a specific date range.In simple words, you want when a user enters a date in a cell that should be within a range of dates which you specify.Well, this can be done by using a custom formula based […]